Horton

Re: timeout implementation issues

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Hiroshi Inoue <Inoue@tpf.co.jp>, Peter Eisentraut <peter_e@gmx.net>, Michael Loftis <mloftis@wgops.com>, PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2002-04-10T04:30:32Z
Lists: pgsql-hackers 
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