PgSql

LogStandbySnapshot (was another thread)
Simon Riggs wrote: On Tue, 2010-05-04 at 13:23 -0400, Tom Lane wrote: * LogStandbySnapshot is merest fantasy: no guarantee that either the XIDs list or the locks list will be consistent with the point in WAL where it will get inserted. What's worse, locking things down enough to guarantee consis... 6 May 2010 04:12

Need to contact driver authors about change in indexnaming behavior ...
On Tue, May 04, 2010 at 04:40:22PM -0700, Josh Berkus wrote: Hackers, Driver maintainers, The 9.0 "don't rename index cols" behavior has already broken JDBC. We need to get in touch with other driver authors to see if they are affected by this, and to let them know that they'll need a new driver rel... 4 May 2010 22:24

[HACKERS] LogStandbySnapshot (was another thread)
On Tue, 2010-05-04 at 13:23 -0400, Tom Lane wrote: * LogStandbySnapshot is merest fantasy: no guarantee that either the XIDs list or the locks list will be consistent with the point in WAL where it will get inserted. What's worse, locking things down enough to guarantee consistency would be horrid for pe... 4 May 2010 20:12

[HACKERS] GUCs that need restart
There are quite a few GUC parameters that need restart. Is there a way we can avoid some of them needing restart? I am specifically looking at archive_mode and the new wal_level. From my limited understanding, these parameters need restart because in a running cluster we cannot safely change these GUCs and make s... 4 May 2010 17:58

Reg: SQL Query for Postgres 8.4.3
On 04/05/10 18:47, Srinivas Naik wrote: Hi, Can any one tell me whats the effect of the below Query SELECT substring(B'1111000000000001' from 5 for -2); SELECT substring(B'1111000000000001' from 4 for -3); its observed that there's an Error "invalid memory alloc request size 4244635647" What will... 5 May 2010 20:30

Pause/Resume feature for Hot Standby
Simon Riggs <simon(a)2ndQuadrant.com> writes: In the original patch I had Pause/Resume feature for controlling recovery during Hot Standby. It was removed for lack of time. With all the discussion around the HS UI, it would be something that could be back very easily. Please! Manual control over re... 4 May 2010 16:50

[HACKERS] Pause/Resume feature for Hot Standby
In the original patch I had Pause/Resume feature for controlling recovery during Hot Standby. It was removed for lack of time. With all the discussion around the HS UI, it would be something that could be back very easily. I would like to do it as a recovery control plugin. The plugin would be passed 3 piece... 4 May 2010 04:38

[HACKERS] Reg: SQL Query for Postgres 8.4.3
Hi, Can any one tell me whats the effect of the below Query SELECT substring(B'1111000000000001' from 5 for -2); SELECT substring(B'1111000000000001' from 4 for -3); its observed that there's an Error "invalid memory alloc request size 4244635647" What will actually happen to the Postgresql database. ... 4 May 2010 03:32

what is good solution for support NULL inside string_to_array function?
Josh Berkus <josh(a)agliodbs.com> writes: quietly removing NULL is maybe good for compatibility but is wrong for functionality. I agree. I wasn't aware of this little misfeature. Default display for NULL should be a zero-length string. That's just as broken as Pavel's suggestion. Unless you have s... 4 May 2010 11:12

what is good solution for support NULL inside string_to_arrayfunction?
quietly removing NULL is maybe good for compatibility but is wrong for functionality. I agree. I wasn't aware of this little misfeature. Default display for NULL should be a zero-length string. -- -- Josh Berkus PostgreSQL Exper... 7 May 2010 14:31