PgSql

[HACKERS] unfathomable comment in psqlscan.l
While reviewing Pavel's patch for variable quoting in psql, I came upon the following comment in psqlscan.l: /* * The variable value is just emitted without any * further examination. This is consistent with the * pre-8.0 code behavior, if not with the way that * var... 26 Jan 2010 14:22

Review of Writeable CTE Patch
On Tue, Jan 26, 2010 at 9:13 AM, Merlin Moncure <mmoncure(a)gmail.com> wrote: *) Works as advertised...'feels right'.  Found only one small issue which Marko was already aware of and had adjusted for. [...] Marko was already aware of it and has a fix ready. So it sounds like we should expect an updated patch... 3 Feb 2010 16:17

ECPGset_var
Hi, Michael Meskes írta: Zoltan, could you please look into this: http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=dugong&dt=2010-01-26%2011:05:01 ? Apparently dugong creates the ECPGset_var statements in a different order than the other archs. Michael It seems mongoose also fails the same wa... 2 Feb 2010 16:06

Dividing progress/debug information in pg_standby, and stat before copy
Hi! On Mon, Jan 25, 2010 at 1:34 PM, Greg Smith <greg(a)2ndquadrant.com> wrote: Josh Berkus wrote: We discussed this issue at LCA where I encountered these bogus error messages when I was doing the demo of HS.  I consider Selena's patch to be a bug-fix for beta of 9.0, not a feature.  Currently the ... 27 Jan 2010 20:35

Package namespace and Safe init cleanup for plperl[PATCH]
On Fri, Jan 15, 2010 at 04:02:02AM +0000, Tim Bunce wrote: This is the final plperl patch in the series from me. Changes in this patch: - Moved internal functions out of main:: namespace into PostgreSQL::InServer and PostgreSQL::InServer::safe - Restructured Safe compartment setup code ... 14 Feb 2010 07:22

[HACKERS] C function accepting/returning cstring vs. text
I'm having a hard time trying to understand how everything should be done in C extensions. Now I'm trying to understand how and when I should accept/return cstring vs text and if and how I should take care of any encoding. I'm trying to output the content of a tsvector as a set of record pos, weight, text|cstr... 25 Jan 2010 16:13

Clustering Docs WAS: Mammoth in Core?
All, Please rename this thread. I think that several people to whom it's relevant aren't replying to it because of the deceptive name. Thanks. --Josh -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hac... 27 Jan 2010 20:35

[HACKERS] Dividing progress/debug information in pg_standby, and stat before copy
Hi! I poked around a little at pg_standby because of some 'cp: file does not exist' errors that were cropping up as pg_standby searched around for .history files. I added a stat that still outputs debugging information but now we don't get cp failures, and then added a 'progress' mode. It was a bit of a seman... 25 Jan 2010 12:48

pg_listener entries deleted under heavy NOTIFY load only on Windows
On Monday, January 25, 2010, Stefan Kaltenbrunner <stefan(a)kaltenbrunner.cc> wrote: Craig Ringer wrote: On 23/01/2010 5:30 AM, Radu Ilie wrote: On a Windows server under heavy load of NOTIFY events, entries in pg_listener table for some events are deleted. It is like UNLISTEN was called. T... 2 Feb 2010 16:09

pg_listener entries deleted under heavy NOTIFY loadonly on Windows
On 23/01/2010 5:30 AM, Radu Ilie wrote: On a Windows server under heavy load of NOTIFY events, entries in pg_listener table for some events are deleted. It is like UNLISTEN was called. This has been reported on -general, then -bugs, now -hackers, and seems to just get ignored. The poster has done a fair b... 25 Jan 2010 08:18