Re: DBI, savepoints, transactions, and AutoCommit -- NOT A BUG - Mailing list pgsql-novice

From felix@crowfix.com
Subject Re: DBI, savepoints, transactions, and AutoCommit -- NOT A BUG
Date
Msg-id 20111103174757.GJ5551@crowfix.com
Whole thread Raw
In response to Re: DBI, savepoints, transactions, and AutoCommit -- NOT A BUG  (felix@crowfix.com)
List pgsql-novice
On Wed, Nov 02, 2011 at 04:53:18PM -0700, felix@crowfix.com wrote:
> On Wed, Nov 02, 2011 at 06:05:56PM -0400, Daniel Staal wrote:
>
> > Also, do you have any example code that shows the problem?
>
> Well shiver me timbers!  I wrote a sample program ... and it works.  I
> could have sworn I was logging all SQL executed, but it looks like
> something is slipping by.  I've attached the program just to be
> thorough.

Found the logic misflow -- some ancient old code was trying to be
helpful and rolled back the entire transaction after a dup was
detected.  Works better without that ...

--
            ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
     Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
  GPG = E987 4493 C860 246C 3B1E  6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o

pgsql-novice by date:

Previous
From: Doug Wiebe
Date:
Subject: Foreign key constraint violation when using table inheritance
Next
From: Bob McConnell
Date:
Subject: Re: DBI, savepoints, transactions, and AutoCommit -- NOT A BUG