PgSql

[HACKERS] row estimation off the mark when generate_series calls are involved
Another email which went into the wilderness when I sent it to pgsql-patches. Regards, Nikhils ---------- Forwarded message ---------- From: Nikhil Sontakke <nikhil.sontakke(a)enterprisedb.com> Date: Fri, Apr 16, 2010 at 6:50 PM Subject: row estimation off the mark when generate_series calls are involved To:... 20 Apr 2010 16:15

[HACKERS] CTAS not honoring NOT NULL, DEFAULT modifiers
Guess no-one got to read this email. I sent it to pgsql-patches without realizing that it is a dead-list. Shouldn't we atleast bounce emails back to senders if they send an email to pgsql-patches? Regards, NIkhils ---------- Forwarded message ---------- From: Nikhil Sontakke <nikhil.sontakke(a)enterprisedb.co... 20 Apr 2010 16:15

BETA
On Tue, 20 Apr 2010, Robert Haas wrote: /me pushes luck And how about a set of back-branch releases while we're at it? We tend to try and avoid overlapping a "release" with a "beta" to avoid confusion ... but didn't we just do a fresh back branch release anyway? ---- Marc G. Fournier ... 24 Apr 2010 09:25

RPM script bug #5430
Tom forwarded it to RPM list. I'll take care of it soon. On Tue, 2010-04-20 at 05:51 -0700, Jamie Strachan wrote: Hello, I posted Bug #5430, "initdb script fails due to permissions of /usr/share/pgsql/" I would be happy to fix this bug and submit a patch. However, I don't seem to see the RPM... 20 Apr 2010 18:32

enable_material patch
Robert Haas <robertmhaas(a)gmail.com> writes: Here's a patch to add enable_material, per previous discussion. I still think we should add enable_joinremoval also, but there wasn't a clear consensus for that. I'd appreciate it if someone could check this over for sanity - like, did I get all the places w... 18 Apr 2010 21:56

[PATCH] fix segfault with DO and plperl/plperlu
Alex Hunsaker <badalex(a)gmail.com> writes: If you do: # DO $do$ 1; $do$ LANGUAGE plperlu; # DO $do$ 1; $do$ LANGUAGE plperl; You get a segfault as we try to SvREFCNT_dec(...); for the wrong interpreter. To fix push down the restore_context() so that we do the above on the correct perl interpreter. ... 18 Apr 2010 17:31

patch: Distinguish between unique indexes and unique constraints
On Sat, Apr 17, 2010 at 11:53 PM, Josh Kupershmidt <schmiddy(a)gmail.com> wrote: Addressing TODO item "Distinguish between unique indexes and unique constraints in \d+" for psql, and picking up from thread: http://archives.postgresql.org/message-id/8780.1271187360(a)sss.pgh.pa.us Attached is a simple patch w... 18 Apr 2010 11:57

[HACKERS] [PATCH] fix segfault with DO and plperl/plperlu
If you do: # DO $do$ 1; $do$ LANGUAGE plperlu; # DO $do$ 1; $do$ LANGUAGE plperl; You get a segfault as we try to SvREFCNT_dec(...); for the wrong interpreter. To fix push down the restore_context() so that we do the above on the correct perl interpreter. -- *** a/src/pl/plperl/plperl.c --- b/src/pl/plper... 18 Apr 2010 04:16

[HACKERS] patch: Distinguish between unique indexes and unique constraints
Addressing TODO item "Distinguish between unique indexes and unique constraints in \d+" for psql, and picking up from thread: http://archives.postgresql.org/message-id/8780.1271187360(a)sss.pgh.pa.us Attached is a simple patch which clarifies unique constraints with "UNIQUE CONSTRAINT" in psql's \d+ description of ... 17 Apr 2010 23:59

[HACKERS] enable_material patch
Here's a patch to add enable_material, per previous discussion. I still think we should add enable_joinremoval also, but there wasn't a clear consensus for that. I'd appreciate it if someone could check this over for sanity - like, did I get all the places where materialize nodes can be created? and, did i pre... 17 Apr 2010 23:59