Subject Verb rollback/undo in PostgreSQL
Author Ann W. Harrison
Hi!

Is there anyone on this list who knows whether
PostgreSQL supports a verb-level undo? Specifically,
if you have an update or delete statement that affects
multiple rows, and get, for example, a constraint
failure on one row, does PostgreSQL undo all the changes
of the statement, leaving the transaction intact?


Regards,


Ann