Re: AW: AW: [HACKERS] TRANSACTIONS

At 11:34 AM 2/24/00 -0500, Tom Lane wrote:

>We ought to consider ways of providing the same behavior in psql,
>but it's not gonna happen for 7.0 --- too big a change for beta.

Oh, yeah, no doubt about that.

>> I suspect that most applications don't notice the difference.   Most
>> will catch errors and roll back the current transaction, because that's
>> the logical thing to do in most cases.
>
>You are assuming that the app has the intelligence to do so.  A psql
>script, for example, lacks that intelligence.

I did say "most", not "all".  

>
>I do agree that this is an area where we need to do some work, but
>it's not going to be a simple or small change.  We will need nested-
>transaction support in the backend, and some very careful rethinking
>of the client interfaces to try to avoid breaking existing apps.

Well...Oracle provides "autocommit" as a convenience.  Perhaps we
could let the user select between old-style or SQL92-compliant behavior
during a transition period?



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.