Re: A transaction in transaction? Possible? - Mailing list pgsql-sql

Sorry, but I understand that your example is not really about nested
transactions, but about sequential transactions.

so, the primary question remains:

how to commit/rollback them ?

--- Michael Fuhr <__> wrote:

> On Wed, Nov 10, 2004 at 09:23:02AM +0300, sad wrote:
> > On Tuesday 09 November 2004 18:24, Theodore Petrosky wrote:
> > > I thought nested transactions are available in the new
> > > release (8) coming up.
> > 
> > how to commit/rollback them ?
> 
> CREATE TABLE person (id SERIAL PRIMARY KEY, name TEXT NOT NULL);
> 
> BEGIN;
> INSERT INTO person (name) VALUES ('Tom');
> SAVEPOINT foo;
> INSERT INTO person (name) VALUES ('Dick');
> ROLLBACK TO foo;
> INSERT INTO person (name) VALUES ('Harry');
> COMMIT;
> 
> SELECT * FROM person;
>  id | name  
> ----+-------
>   1 | Tom
>   3 | Harry
> (2 rows)
> 
> -- 
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>