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

Re: Nested Transaction TODO list

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: Nested Transaction TODO list
Date: 2004-07-04 04:09:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Tom Lane wrote:
> Oliver Jowett <oliver(at)opencloud(dot)com> writes:
>>Tom Lane wrote:
>>>I haven't looked at JDBC, but at least in the libpq code, what we could
>>>safely do is extend the existing no transaction/in transaction/in failed
>>>transaction field to provide a five-way distinction: those three cases
>>>plus in subtransaction/in failed subtransaction.
>>This will break the existing JDBC driver in nonobvious ways: the current 
>>code silently ignores unhandled transaction states in ReadyForQuery,
> Drat.  Scratch that plan then.  (Still, silently ignoring unrecognized
> states probably wasn't a good idea for the JDBC code...)

True, but the alternative (screaming and yelling) would also have 
broken, just more obviously.

Actually, thinking about it, that behaviour only changed recently, and 
from memory the older code completely ignored the transaction state in 
ReadyForQuery. The new driver probably hasn't spread too far yet. I'll 
sort out a patch so the driver breaks more obviously if it gets 
something unexpected.

I still don't think that knowing you're in a subtransaction is very 
useful unless you also know the nesting level.


In response to

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2004-07-04 04:10:52
Subject: Re: LinuxTag wrapup
Previous:From: Mike MascariDate: 2004-07-04 03:33:35
Subject: Re: LinuxTag wrapup

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