recursed transactions ? - Mailing list pgsql-general

From Sergei Chernev
Subject recursed transactions ?
Date
Msg-id 000601bde0a4$156cc470$59d17cc1@ser.cnit.nsu.ru
Whole thread Raw
List 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@nsu.ru
Phone: +7-3832-397354


pgsql-general by date:

Previous
From: "Jose' Soares"
Date:
Subject: NOTICE: _outNode: don't know how to print type 715
Next
From: Howie
Date:
Subject: subscribe pgsql-general