Nested Transactions

I don't believe postgresql supports nested transactions yet.

Wes Sheldahl

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

To: pgsql-general%postgresql.org@interlock.lexmark.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

cbroussard@liquiddatainc.com (Chris) writes:

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

PostgreSQL currently doesn't have nested transactions. They have been
discussed for a future version.

-Doug
--
Doug McNaught Wireboard Industries http://www.wireboard.com/

Custom software development, systems and network consulting.
Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...

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