Re: How to implement nested transactions - Mailing list pgsql-general

"Andrus" <eetasoft@online.ee> writes:
> I want to implement nest transactions like
> begin;
>   CREATE temp table t2 (foo char(20) primary key);
>   begin;
>     CREATE temp table t1 (bar char(20) primary key);
>     commit;
>   rollback;

That is not the correct syntax.  Use SAVEPOINT, then ROLLBACK TO SAVEPOINT
or RELEASE SAVEPOINT.

            regards, tom lane