PgSql

Testing plperl<->plperlu interaction
Tim Bunce wrote: I was investigating a bug in an 8.4.1 production system and distilled a test case down to this: CREATE OR REPLACE FUNCTION bar() RETURNS integer AS $$ #die 'BANG!'; # causes server process to exit(2) # alternative - causes server process to exit(255) ... 8 Jan 2010 21:47

[HACKERS] Testing plperl<->plperlu interaction
I was investigating a bug in an 8.4.1 production system and distilled a test case down to this: CREATE OR REPLACE FUNCTION bar() RETURNS integer AS $$ #die 'BANG!'; # causes server process to exit(2) # alternative - causes server process to exit(255) spi_exec_query("invalid sql statem... 6 Jan 2010 18:48

[HACKERS] unresolved bugs
Over the past few months, I've been attempting to keep tracks of which postings on pgsql-bugs have not gotten a response and to respond to those where I have a clue what the issue might be. However, there are a few that I don't really have an idea about which look like they might be real bugs... or some of them mi... 6 Jan 2010 15:25

snapshot generation broken again...
Stefan Kaltenbrunner <stefan(a)kaltenbrunner.cc> writes: Looks like somebody broke the snapshot generation script again: [ scratches head... ] "make dist" works for me. Can you get a trace indicating what command was used to call genbki.pl? regards, tom lane -- Sent via pgsql-hackers mailing list (pgs... 6 Jan 2010 16:33

'replication' keyword on .pgpass (Streaming Replication)
On Wed, Jan 6, 2010 at 15:02, Alvaro Herrera <alvherre(a)commandprompt.com> wrote: Fujii Masao escribió: On Sat, Dec 26, 2009 at 10:55 AM, Fujii Masao <masao.fujii(a)gmail.com> wrote: On Fri, Dec 25, 2009 at 9:56 PM, Andrew Dunstan <andrew(a)dunslane.net> wrote: I don't see the use case for it - .pgpass i... 7 Jan 2010 10:10

'replication' keyword on .pgpass (StreamingReplication)
Fujii Masao escribi�: On Sat, Dec 26, 2009 at 10:55 AM, Fujii Masao <masao.fujii(a)gmail.com> wrote: On Fri, Dec 25, 2009 at 9:56 PM, Andrew Dunstan <andrew(a)dunslane.net> wrote: I don't see the use case for it - .pgpass is for single users, not a whole cluster. And it does support wildcards, which tak... 6 Jan 2010 09:11

tribble.postgresql.org - planned maintenance downtime
Stefan Kaltenbrunner wrote: Hi all! There will be planned downtime on tribble.postgresql.org Jan 6(tomorrow) from 10:00-12:30 GMT(estimated) affecting the following services: cvs.postgresql.org wwwmaster.postgresql.org www.pgadmin.org doxygen.postgresql.org Downtime is necessary to i... 6 Jan 2010 11:58

[HACKERS] Change Catalog
Hi, I can access to system catalog using syscache functions. How can i change the values of cache (e.g. change an attribute in pg_authid)? Are syscache functions readonly? Thanks - B. L. ... 6 Jan 2010 09:11

[HACKERS] Type modifiers for DOMAIN
Hi, I'm trying to use DOMAIN as just synonym types for database migration. For example, =# CREATE DOMAIN varchar2 AS pg_catalog.varchar; =# CREATE DOMAIN number AS pg_catalog.numeric; Domains were created successfully, but I cannot use type modifiers for them. =# CREATE TABLE tbl (v varchar2(10));... 6 Jan 2010 09:10

[HACKERS] ecpg compile error
I am seeing a compile failure in current CVS because my operating system, BSD/OS, does not have inttypes.h: ccache gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -fno-strict-aliasing -O1 -Wall -Wmissing-prototypes -Wmissing-declarations -Wpointer-arith -Wcast-align -pthread -D_REENTRANT -D_THREAD_SAFE -D... 6 Jan 2010 09:10