PgSql

[HACKERS] contrib\xml2 package's xpath_table function in PostgreSQL
Hi, We have a huge system based on PostgreSQL with xml2 functions. From the PostgreSQL 8.4 documentation F.38.1. Deprecation notice, it looks like those functions are removed. However, our solution is very huge, and heavily depends on them. 1. Could you please give me some instructions to get them back in the Po... 2 Feb 2010 16:09

pgsql: Augment WAL records for btree delete with GetOldestXmin() to
Simon Riggs <simon(a)2ndQuadrant.com> writes: At the moment a btree delete record will cancel every request 1. no matter how long they have been running 2. no matter if they haven't accessed the index being cleaned (they might later, is the thinking...) That seems seriously horrid. What is the rationale f... 2 Feb 2010 16:09

pgsql: Augment WAL records forbtree delete with GetOldestXmin() to
On Sun, 2010-01-31 at 14:07 -0500, Tom Lane wrote: The commit is a one line change, with parameter to control it, discussed by Heikki and myself in December 2008. I stand by the accuracy of the change; the parameter is really to ensure we can test during beta. Well, I was waiting to see if anyo... 2 Feb 2010 16:09

Using the new libpq connection functions in PostgreSQLbinaries
On 01/31/2010 09:42 AM, Guillaume Lelarge wrote: I don't find that horrid. AFAICT, that's the only advantage of the two-arrays method. By the way, it's that kind of code (keywords declaration separated from values declaration) that got commited in the previous patch (http://archives.postgresql.org/pgsql-... 2 Feb 2010 16:09

[HACKERS] Package namespace and Safe init cleanup for plperl UPDATE 3 [PATCH]
This is an update to the final plperl patch in the series from me. Changes in the original patch: - Moved internal functions out of main:: namespace into PostgreSQL::InServer and PostgreSQL::InServer::safe - Restructured Safe compartment setup code to generalize and separate the data from the logic. ... 2 Feb 2010 16:09

Hot Standby and VACUUM FULL
Simon Riggs <simon(a)2ndQuadrant.com> writes: The last item on my list before close is making VACUUM FULL and Hot Standby play nicely together. The options to do this were and still are: (1) Add WAL messages for non-transactional relcache invalidations (2) Allow system relations to be cluster-ed/vacuum... 3 Feb 2010 16:17

Add on_perl_init and proper destruction to plperl UPDATE v3[PATCH]
On Fri, Jan 29, 2010 at 09:10:48PM -0500, Andrew Dunstan wrote: Tim Bunce wrote: This is an updated version of the third of the patches to be split out from the former 'plperl feature patch 1'. It includes changes following discussions with Tom Lane and others. Changes in this patch: ... 2 Feb 2010 16:08

Package namespace and Safe init cleanup for plperl [PATCH]
On Mon, Jan 25, 2010 at 12:53, Tim Bunce <Tim.Bunce(a)pobox.com> wrote: - Added the 'warnings' pragma to the list of modules to load into Safe.  So plperl functions can now "use warnings;" - added test for that. *yay* - Added 'use 5.008001;' to plc_perlboot.pl as a run-time check to  complement the con... 14 Feb 2010 07:23

PG 9.0 and standard_conforming_strings
Bruce Momjian <bruce(a)momjian.us> wrote: With the release of Postgres 9.0, should we consider changing the default for 'standard_conforming_strings'? If not now, when? -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.pos... 4 Feb 2010 13:27

[HACKERS] PG 9.0 and standard_conforming_strings
With the release of Postgres 9.0, should we consider changing the default for 'standard_conforming_strings'? -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- ... 2 Feb 2010 16:08