Bruce Momjian <[EMAIL PROTECTED]> writes: > In the case of: > BEGIN WORK; > SET x=1; > bad query that aborts transaction; > SET x=2; > COMMIT WORK;
> Only the first SET is done, so at the end, x = 1. Perhaps even more to the point: SET x=0; BEGIN; SET x=1; bad query; SET x=2; ROLLBACK; Now x=1. How is this sensible? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly