PgSql

[HACKERS] GUC failure on exception
Tim Bunce just showed me the following oddity: andrew=# SET SESSION plperl.use_strict = on; SET andrew=# SHOW plperl.use_strict; plperl.use_strict ------------------- on (1 row) andrew=# DO $$ elog(ERROR,"error") $$ language plperl; ERROR: error at line 1. CONT... 14 Jan 2010 20:18

[HACKERS] Add on_trusted_init and on_untrusted_init to plperl [PATCH]
This is the fourth of the patches to be split out from the former 'plperl feature patch 1'. Changes in this patch: - Adds plperl.on_trusted_init and plperl.on_untrusted_init GUCs Both are PGC_USERSET. SPI functions are not available when the code is run. Errors are detected and reported as ereport... 14 Jan 2010 20:18

Source code for pg_bulkload
On Thu, Jan 14, 2010 at 14:13, Dann Corbit <DCorbit(a)connx.com> wrote: How can I obtain the source code for pg_bulkload? This is the wrong list, try http://lists.pgfoundry.org/pipermail/pgbulkload-general/ That being said it seems to be right in the file list.... http://pgfoundry.org/frs/?group_id=1000261 ht... 14 Jan 2010 16:56

EXPLAIN, utility statement parameters, and recent plpgsql changes
2010/1/14 Tom Lane <tgl(a)sss.pgh.pa.us>: Pavel pointed out here http://archives.postgresql.org/pgsql-hackers/2010-01/msg01233.php that it no longer works to reference plpgsql variables in EXPLAIN statements in plpgsql.  I dug into this a bit, and the code is trying to do it but it doesn't quite work. ... 14 Jan 2010 15:48

[HACKERS] Miscellaneous changes to plperl [PATCH]
This is the second of the patches to be split out from the former 'plperl feature patch 1'. Changes in this patch: - Allow (ineffective) use of 'require' in plperl If the required module is not already loaded then it dies. So "use strict;" now works in plperl. - Pre-load the feature module if perl >... 14 Jan 2010 11:17

[HACKERS] archive_timeout behavior for no activity
Looking at the archive_timeout documentation and CheckArchiveTimeout(), it appears we force a new xlog file and archive it even if no activity has been recorded in the xlog file. Is this correct? Should we document this or fix it so only xlog files with contents are archived? -- Bruce Momjian <bruce(a)momjia... 14 Jan 2010 11:17

Streaming replication, retrying from archive
On Thu, Jan 14, 2010 at 9:15 AM, Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: Imagine this scenario: 1. Master is up and running, standby is connected and streaming happily 2. Network goes down, connection is broken. 3. Standby falls behind a lot. Old WAL files that the standby needs ... 21 Jan 2010 18:03

[HACKERS] Streaming replication, retrying from archive
Imagine this scenario: 1. Master is up and running, standby is connected and streaming happily 2. Network goes down, connection is broken. 3. Standby falls behind a lot. Old WAL files that the standby needs are archived, and deleted from master. 4. Network is restored. Standby reconnects 5. Standby will get an ... 14 Jan 2010 10:09

segmentation fault in function
Sergej Galkin <sergej.galkin(a)gmail.com> writes: I am realizing gist index and get a bug, that crashes DB. I' debugged my program as Robert(thanks !) advised me and I know which procedure crashed. Using gdb you should have the line number in the source code and should be able to look up the variable value... 14 Jan 2010 05:46

[HACKERS] review: More frame options in window functions
Hello I looked on Hitoshi's patch - and my result is: 1. Patch is in correct format, it is cleanly applied and compilation is without warnings, 2. Patch contains adequate changes of doc, and rich set of regress tests, 3. If I could to understand to implemented feature - it is in conformity with SQL standard, ... 14 Jan 2010 05:46