Re: Nested Transactions

I don't believe postgresql supports nested transactions yet.

Wes Sheldahl

cbroussard%liquiddatainc(dot)com(at)interlock(dot)lexmark(dot)com (Chris) on 03/08/2002
02:12:33 AM

To: pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)com
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: [GENERAL] Nested Transactions

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