Re: Nested Transactions

Поиск
Список
Период
Сортировка
От wsheldah@lexmark.com
Тема Re: Nested Transactions
Дата
Msg-id 200203131805.NAA14241@interlock2.lexmark.com
обсуждение исходный текст
Ответ на Nested Transactions  (cbroussard@liquiddatainc.com (Chris))
Список pgsql-general

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





В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Arrays
Следующее
От: Manuel Martin
Дата:
Сообщение: how to get info about spatial extension of pgsql?