From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Chris <cbroussard(at)liquiddatainc(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Nested Transactions |
Date: | 2002-03-13 20:03:15 |
Message-ID: | 200203132003.g2DK3FG03542@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2002-03-13 20:16:13 | Re: more about pg_toast growth |
Previous Message | Tom Lane | 2002-03-13 20:01:39 | Re: Zlib vulnerability heads-up. |