Skip site navigation (1) Skip section navigation (2)

Re: DBI, savepoints, transactions, and AutoCommit -- NOT A BUG

From: felix(at)crowfix(dot)com
To: PGSQL-Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: DBI, savepoints, transactions, and AutoCommit -- NOT A BUG
Date: 2011-11-03 17:47:57
Message-ID: 20111103174757.GJ5551@crowfix.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, Nov 02, 2011 at 04:53:18PM -0700, felix(at)crowfix(dot)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(at)crowfix(dot)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

In response to

pgsql-novice by date

Next:From: Bob McConnellDate: 2011-11-03 22:05:51
Subject: Re: DBI, savepoints, transactions, and AutoCommit -- NOT A BUG
Previous:From: felixDate: 2011-11-03 00:39:20
Subject: Re: DBI, savepoints, transactions, and AutoCommit -- NOT A BUG

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group