PgSql

Hot Standby 0.2.1
On Tue, Sep 15, 2009 at 10:41:59PM +0100, Simon Riggs wrote: OK, here is the latest version of the Hot Standby patchset. This is about version 30+ by now, but we should regard this as 0.2.1 Patch against CVS HEAD (now): clean apply, compile, no known bugs. Kudos!!!! Cheers, David. -- David Fette... 9 Oct 2009 14:54

PGCluster-II Progress
I had the same question a while a go. After a lot of googling I found http://www.cybertec.at/english/start_e.html This seems to be an active replacement for the dead? pg-cluster HTH Regards, Serge Fonville On Tue, Sep 15, 2009 at 1:29 PM, Marcos Luis Ortiz Valmaseda <mlortiz(a)uci.cu wrote: I was se... 20 Sep 2009 07:23

Timestamp to time_t
Scott Mohekey <scott.mohekey(a)telogis.com> wrote: What is the relationship between Timestamp and TimestampTz? TIMESTAMP WITHOUT TIME ZONE does not identify a moment in time without first associating it with a time zone. When Daylight Saving Time ends, the same TIMESTAMP WITHOUT TIME ZONE values will recur, ... 15 Sep 2009 20:18

WIP: generalized index constraints
2009/8/21 Brendan Jurd <direvus(a)gmail.com>: 2009/8/21 Jeff Davis <pgsql(a)j-davis.com>: On Fri, 2009-08-21 at 12:23 +1000, Brendan Jurd wrote: The current behaviour seems to be predicated on the unique constraint being an integral part of the index itself.  While this might be true from a system cat... 21 Sep 2009 10:00

corrupted double-linked list
Maarten =?ISO-8859-1?Q?Foqu=E9?= <maarten.foque(a)edchq.com> writes: The program crashes on PQclear(resu) with the following: *** glibc detected *** ./incident_relay: corrupted double-linked list: 0x09c459c8 *** This looks like a memory-stomp type of bug. There's no reason to assume that PQclear is the caus... 10 Sep 2009 10:14

[HACKERS] integer input functions : interesting limit behaviour
I was looking in the int*in() functions and found some interesting limit behaviours : * Here, the most negative value is sometimes accepted, sometimes not : test=> SELECT -2147483648::INTEGER; ERREUR: entier en dehors des limites test=> SELECT '-2147483648'::INTEGER; int4 ------------- -2147... 8 Sep 2009 08:06

[HACKERS] Hot Standby, max_connections and max_prepared_transactions
We discussed earlier that HS should continue to work even if max_connections was set differently on the primary and the standby. This now gives a situation where snapshots can be allowed, then disallowed for a while, then allowed again. Complication is that this will cause some connections to fail since we tak... 3 Sep 2009 15:06

gcc versus division-by-zero traps
On Thu, Sep 03, 2009 at 10:24:17AM -0400, Tom Lane wrote: We have seen several previous reports of regression test failures due to division by zero causing SIGFPE, even though the code should never reach the division command: http://archives.postgresql.org/pgsql-bugs/2006-11/msg00180.php http://archi... 17 Sep 2009 19:17

combined indexes with Gist - planner issues?
Hi, Hans-Juergen Schoenig -- PostgreSQL wrote: we did some experiments with doing such a table. the problem is if you want to allow arbitrary combinations of words which can be modeled perfectly with FTI. you would instantly end up with a self join with 5 relations or so - which is again bad. t... 3 Sep 2009 07:52

Comments to Synchronous replication patch v3
"Fujii Masao" <masao.fujii(a)gmail.com> wrote: On Fri, Nov 14, 2008 at 7:15 PM, Fujii Masao <masao.fujii(a)gmail.com> wrote: Attached is the latest version of Synch Rep patch. Sorry for my late posting. I fixed some bugs in v1patch and integrated walreceiver into core. I have some comments about v3 patch. ... 30 Nov 2008 21:22