Peter Eisentraut <peter_e@gmx.net> writes:
> No, I think there is another problem. How about something without
> selects:
> $ psql -c 'delete from pk; delete from xx;'
> ERROR: Relation 'xx' does not exist
> "pk" exists, but nothing is deleted.
Sure, because the transaction is rolled back. The whole string
is executed in one transaction. You will definitely break existing
applications if you change that.
regards, tom lane
