
> As far as implementing only savepoints, look at this:
> 
> BEGIN;
> 	BEGIN;
> 	INSERT INTO ...;
> 	COMMIT;
> 	BEGIN;
> 	INSERT INTO ...;
> 	COMMIT;
> 	BEGIN;
> 	INSERT INTO ...;
> 	COMMIT;
> 
> With savepoints, it looks pretty strange:
> 	
> BEGIN;
> 	SAVEPOINT x1;
> 	INSERT INTO ...;
> 	SAVEPOINT x2;

If you meant same as your nested example, it would be:

BEGIN TRANSACTION;
	SAVEPOINT x;
	INSERT INTO ...;
	SAVEPOINT x;	-- this implicitly commits previous subtxn x
	INSERT INTO ...;
	SAVEPOINT x;
	INSERT INTO ...;
COMMIT;

Andreas

Fri, 9 Jul 2004 12:09:16 +0200
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>
Re: Nested Transactions, Abort All