
> > 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 thought that psql is the only frontend that would not have a problem
with the new behavior, because it now has the feature of "exit on first
error"
and thus rolls back the last open transaction anyway.

> 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.

Yes, unfortunately.

Andreas

Thu, 24 Feb 2000 17:43:40 +0100
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
AW: AW: AW: [HACKERS] TRANSACTIONS 