Re: timeout implementation issues

Bruce Momjian <pgman@candle.pha.pa.us> 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