PgSql

[HACKERS] LISTEN/NOTIFY versus encoding conversion
There's been a lot of thrashing about whether LISTEN/NOTIFY should restrict payload strings to 7-bit ASCII to avoid possible encoding conversion failures. I was on the side of "yes" but I'm having second thoughts about it. The point I had failed to think about is that we already restrict notifies to only be recei... 14 Feb 2010 16:17

PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl
On Feb 12, 2010, at 3:10 PM, Tim Bunce wrote: I've appended the POD documentation and attached the (rough but working) test script. I plan to release the module to CPAN in the next week or so. I'd greatly appreciate any feedback. I like the idea overall, and anything that can simplify the inter... 18 Feb 2010 13:58

[HACKERS] "0 0" return tag
I have updated the attached C comment about why we return "0 0" for some tags. -- 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. + ... 14 Feb 2010 07:22

[HACKERS] psycopg2 license changed
Hi *, I just wanted all interested people know that psycopg2 2.0.14 to be released in the next few days will be under the LGPL3 + OpenSSL exception (example code and tests under the LGPL3 alone because they are never linked to OpenSSL). The Zope 2 and 3 adapters will be splitted out into their own packages af... 14 Feb 2010 07:22

[HACKERS] CommitFest Status Summary - 2010-02-14
We're down to 5 patches remaining, and 1 day remaining, so it's time to try to wrap things up. * Fix large object support in pg_dump. I think this is just waiting for a second opinion on whether the approach is correct. I've been meaning to look at it, but haven't gotten enough round tuits; maybe someone else ... 14 Feb 2010 07:22

PostgreSQL::PLPerl::Call - Simple interface for calling SQLfunctions from PostgreSQL PL/Perl
On Fri, Feb 12, 2010 at 11:10:15PM +0000, Tim Bunce wrote: I've appended the POD documentation and attached the (rough but working) test script. Oops. Here's the test script. Tim. ... 12 Feb 2010 19:06

[HACKERS] WITH ... VALUES
Came across something interesting while looking at Marko Tiikkaja's cut-down WITH patch. I see that our grammar allows a WITH clause in front of VALUES, and analyze.c makes some effort to process it, but AFAICT there isn't any actual use case for this because you can't reference the WITH clause from the body of VA... 12 Feb 2010 17:59

pgsql: Make standby server continuouslyretry restoring the next WAL
Simon Riggs wrote: In 8.4 it is pg_standby that was responsible for clearing down the archive, which is why I suggested using pg_standby for that again. I agree that will not work. The important thing is not pg_standby but that we have a valid mechanism for clearing down the archive. Good point. When str... 12 Feb 2010 08:55

pgsql: Make standby servercontinuously retry restoring the next WAL
On Thu, Feb 11, 2010 at 01:22:44PM -0500, Kevin Grittner wrote: Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: I think 'rsync' has the same problem. There is a switch you can use to create the problem under rsync, but by default rsync copies to a temporary file name and moves th... 12 Feb 2010 06:42

Bug on pg_lesslog
On Thu, 2010-02-11 at 23:39 +0900, Koichi Suzuki wrote: Dear Folks; A very serious bug was reported on pg_lesslog. So far, I found it's a bug in pg_compresslog. Please do not use pg_compresslog and pg_decompresslog until improved version is uploaded. I strongly advise to take base backup of y... 12 Feb 2010 06:42