[BUGS] JDBC Trouble when exception appears .

Hello,I got some pb with this configuration database pgsql 7.1 and connect with jdbc driver from 7.2 I notice something that could be a jdbc bugs :when connection is not set to autocommit (setAutocommit(false))When you catch an exception, the next requests until the next commit are totaly ing

Re: [BUGS] Bug #613: Sequence values fall back to previously checkpointed

Justin wrote: > Hi Tom, > > On Tuesday 12 March 2002 16:17, Tom Lane wrote: > > > > > Can anyone see a way that this mechanism explains the prior reports? > > Not sure about that, but I really feel the fix for this should go into 7.2.1, > just in case the list of patches for that is still bein

Re: [BUGS] Bug #613: Sequence values fall back to previously checkpointed

Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > [EMAIL PROTECTED] wrote: > >> the sequence again. Kill -9 the postmaster. Tried to insert into the > >> table, but to no avail... duplicate key. currval of the sequence and > >> it matched the value right after the checkpoint. I

Re: [BUGS] Bug #613: Sequence values fall back to previously checkpointed

Bruce Momjian <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] wrote: >> the sequence again. Kill -9 the postmaster. Tried to insert into the >> table, but to no avail... duplicate key. currval of the sequence and >> it matched the value right after the checkpoint. I've been able to >> dupli

Re: [BUGS] Bug #613: Sequence values fall back to previously checkpointed

[EMAIL PROTECTED] wrote: > On Tue, 12 Mar 2002, Tom Lane wrote: > > > > > The "no commit record" part of the logic seems okay to me, but we need > > an independent test to decide whether to write/flush XLog. If we have > > reported a nextval() value to the client then it seems to me we'd better

[BUGS] Build of PostgreSQL under Irix

Here is the script that I use to build PostgreSQL under Irix. The configure scripts works just fine, and all regression tests past (join gives a compliant but different record order). #!/bin/ksh -x export SGI_ABI=-64 cat >config.cache <>pg_hba.conf