Subject | Verb rollback/undo in PostgreSQL |
---|---|
Author | Ann W. Harrison |
Post date | 2006-05-01T16:59:28Z |
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
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