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