PgSql

[HACKERS] ECPG dynamic cursor fix for UPDATE/DELETE ... WHERE CURRENT OF :curname
Hi, attached is a patch that adds the missing feature to use "WHERE CURRENT OF :curname" in UPDATE and DELETE statements via ECPG. I used the current CVS MAIN but also applies almost cleanly to 9.0beta4. I certainly feel that this should be applied to 9.0 as a bugfix. The execute.c changes were required becau... 3 Aug 2010 16:57

reducing NUMERIC size for 9.1, take two
On 31 July 2010 07:58, Robert Haas <robertmhaas(a)gmail.com> wrote: Here's a second version of the main patch, in which I have attempted to respond to Tom's concerns/suggestions. (There is still a small, side issue with numeric_maximum_size() which I plan to fix, but this patch is the good stuff.) Ap... 3 Aug 2010 20:15

Two problems when using Postgresql8.3.7, Please help me!
On Tue, Aug 3, 2010 at 12:34 PM, Richard <husttripper(a)vip.sina.com> wrote: 1.To�add�live�HA��to�PG,�I�transfer�WAL�of�a�database�instance(Primary node)�to�another�database�instance�(standby�node)�at�real�time,�and keep�startup�alive�in�standby�node�to�recovery�WAL�online,so�that standby�node�can�be�a�hot�standby. ... 3 Aug 2010 15:51

Two problems when using Postgresql8.3.7, Please helpme!
On Wed, 2010-08-04 at 00:34 +0800, Richard wrote: 1.To add live HA to PG, I transfer WAL of a database instance(Primary node) to another database instance (standby node) at real time, and keep startup alive in standby node to recovery WAL online,so that standby node can be a hot standby. But I got some trouble. ... 3 Aug 2010 15:51

ECPG dynamic cursor fix for UPDATE/DELETE ... WHERE CURRENT OF :curname
Boszormenyi Zoltan <zb(a)cybertec.at> wrote: attached is a patch that adds the missing feature I certainly feel that this should be applied to 9.0 as a bugfix. Those two statements seem to contradict one another. Is there some bug manifestation beyond an unimplemented feature this fixes? Without this,... 5 Aug 2010 13:33

[HACKERS] Two problems when using Postgresql8.3.7, Please help me!
1.To add live HA to PG, I transfer WAL of a database instance(Primary node) to another database instance (standby node) at real time, and keep startup alive in standby node to recovery WAL online,so that standby node can be a hot standby. But I got some trouble. When standby node switch to primary mode to accept conn... 3 Aug 2010 15:51

tracking inherited columns (was: patch for check constraints using multiple inheritance)
On Tue, Aug 3, 2010 at 3:05 PM, Yeb Havinga <yebhavinga(a)gmail.com> wrote: Yeb Havinga wrote: The underlying cause is the failure of the code to recognize that if relation C inherits from both A and B, where A and B both have column x, that A.x 'is the same as' B.x, where the 'is the same as' relation is ... 5 Aug 2010 15:47

Patch to show individual statement latencies in pgbench output
Florian Pflug wrote: I created the patch to tune the wal_writer for the synchronous_commit=off case - the idea being that the COMMIT should be virtually instantaneous if the wal_writer writes old wal buffers out fast enough. As I was saying, being able to see the COMMIT times for purposes such as that is ... 3 Aug 2010 15:51

pgsql: Add \conninfo command to psql, to show current connection info.
On Tue, Aug 3, 2010 at 1:46 PM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: 1. This way would match the argument ordering for \connect, which in case you've forgotten is dbname user host port. I noticed that discrepancy when reviewing, but felt it was a problem for another day. Today is fine, though. :-) -- Ro... 3 Aug 2010 15:51

[COMMITTERS] pgsql: Add \conninfo command to psql, to show current connection info.
rhaas(a)postgresql.org (Robert Haas) writes: Add \conninfo command to psql, to show current connection info. David Christensen. Reviewed by Steve Singer. Some further changes by me. Looking at the output from this command: regression=# \conninfo You are connected to database "regression" via local socket i... 3 Aug 2010 14:45