Peter Eisentraut <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
