No, sorry, no nested transactions yet. It is on the TODO list.
---------------------------------------------------------------------------
Chris wrote:
> i'm trying to accomplish the following task:
>
> begin transaction;
> begin work;
> create table xyz(
> id int
> );
> commit work;
> select * from xyz;
> rollback transaction;
> select * from xyz; // should say database object doesn't exist
>
> however i'm failing to be able to do this?? is there a specific reason?
>
> I know in MSSQL you can say:
>
> begin transaction
> begin transaction test
> create table xyz(
> id [int]
> );
> select * from xyz
> commit transaction test
> rollback transaction
> select * from xyz // database object doesn't exist
>
> Is there an equivalent?
>
> TIA
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026