recursed transactions ?

From: "Sergei Chernev" <ser(at)nsu(dot)ru>
To: <pgsql-general(at)postgreSQL(dot)org>
Subject: recursed transactions ?
Date: 1998-09-15 12:26:35
Message-ID: 000601bde0a4$156cc470$59d17cc1@ser.cnit.nsu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
Does anybody know, if it possible to make recursed transactions like that:
BEGIN
INSERT ...
UPDATE ...
BEGIN
SELECT ...
UPDATE ....
END
END

psql - tells me:
ser=>begin;
BEGIN
ser=> begin;
NOTICE: BeginTransactionBlock and not in default state
ser=> end;
END
ser=> end;
NOTICE: EndTransactionBlock and not inprogress/abort state
END

Thank you !
---------------------------
Sergei Chernev
Internet: ser(at)nsu(dot)ru
Phone: +7-3832-397354

Browse pgsql-general by date

  From Date Subject
Next Message Howie 1998-09-15 18:40:56 subscribe pgsql-general
Previous Message Jose' Soares 1998-09-15 11:14:32 NOTICE: _outNode: don't know how to print type 715