PgSql

[HACKERS] Upcoming back-branch releases
It's been almost three months since our last minor releases, and we've accumulated enough fixes to justify a new set of updates. The core team is planning to wrap new tarballs next Thursday for release Monday 3/15. If you've got any pending back-branch fixes, get 'em in soon. regards, tom lane -- Sent vi... 4 Mar 2010 00:11

[HACKERS] [PATCH] elimination of code duplication in DefineOpFamily()
It looks like for me the bottom half of the DefineOpFamily() is a block copied and pasted from CreateOpFamily(). It has identical logic, variable names and source code comments. Perhaps, we can replace this code block by CreateOpFamily() call. Thanks, -- KaiGai Kohei <kaigai(a)ak.jp.nec.com> ... 3 Mar 2010 20:54

Getting to 9.0 beta
On Wed, Mar 3, 2010 at 6:28 PM, Bruce Momjian <bruce(a)momjian.us> wrote: I whittled my 1.5k open emails down to [five items] That's a pretty good compression ratio. ....Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql... 3 Mar 2010 19:47

recovery.conf.sample
On Tue, Feb 23, 2010 at 1:44 PM, Fujii Masao <masao.fujii(a)gmail.com> wrote: recovery.conf.sample has the following section for Hot Standby. Is this still required? #--------------------------------------------------------------------------- # HOT STANDBY PARAMETERS #--------------------------------... 3 Mar 2010 08:26

pgsql: Instead of trying (and failing) to allow<<label>> at the end of
On Tue, Mar 02, 2010 at 11:02:54PM -0500, Jaime Casanova wrote: On Tue, Mar 2, 2010 at 8:53 PM, Tom Lane <tgl(a)postgresql.org> wrote: Log Message: ----------- Instead of trying (and failing) to allow <<label>> at the end of a DECLARE section, throw an error message saying explicitly that the label... 3 Mar 2010 01:51

[HACKERS] Hot Standby query cancellation and Streaming Replicationintegration
On Mon, 2010-03-01 at 16:12 -0400, pgsql-hackers-owner(a)postgresql.org wrote: . . . However there is a concern with max_standby_age. If you set it to, say, 300s. Then run a 300s query on the slave which causes the slave to fall 299s behind. Now you start a new query on the slave -- it gets a snapshot ba... 2 Mar 2010 16:57

building postgres-A4.tex-pdf crushed
Oleg Bartunov wrote: just to inform, that building of postgres-A4.tex-pdf (8.4) crushed on my Ubuntu 9.10 machine. No problem with CVS HEAD. Alvaro and I are both having the opposite problem on Ubuntu 9.04: 8.4 works fine, but CVS HEAD dumps core: http://archives.postgresql.org/message-id/20100215141242.... 2 Mar 2010 08:58

Hung postmaster (8.3.9)
We should probably also check and prohibit including directories as files. On Tuesday, March 2, 2010, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: In the meantime, it seems like we ought to take two defensive steps: -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make change... 2 Mar 2010 05:41

[HACKERS] WAL replay does not verify integrity
As demonstrated here: http://archives.postgresql.org/pgsql-general/2010-02/msg01057.php it can happen that you end up with a corrupt database if you use PITR to recover past a hardware failure. It seems that unique constraints are not verified during WAL replay. Is that intentional or an oversight that shou... 2 Mar 2010 03:31

[HACKERS] [Feature request] variable declaration of anonymous composite data type in PL/pgSQL
Hello, Not sure whether it's appropriate list for feature requests though.. Would it be suitable to implement such variable declarations in PL/pgSQL so that following (or similar) constructs would be possible? DECLARE tmpStruct (name varchar, foo integer, bar boolean)[] := array[ ('somename', 1, true), ('s... 1 Mar 2010 18:44