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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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