Re: Nested Transactions - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Nested Transactions
Date
Msg-id 200203132003.g2DK3FG03542@candle.pha.pa.us
Whole thread Raw
In response to Nested Transactions  (cbroussard@liquiddatainc.com (Chris))
List pgsql-general
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PG_XLOG
Next
From: "Jeffrey W. Baker"
Date:
Subject: Re: more about pg_toast growth