On Fri, Jun 25, 2004 at 08:54:57AM -0400, Merlin Moncure wrote:
> I would be fine with changing the lifetime if an EXECUTE failure did not
> abort the current transaction. Then I could simply watch the return
> code of the statement execution and prepare the statement on
> demand...from my point of view, this would actually be the most elegant
> scenario.
BEGIN;
... do something ... ;
SUBBEGIN;
EXECUTE ...;
-- if it fails:
-- SUBABORT;
-- PREPARE ...;
-- SUBBEGIN;
-- EXECUTE ...;
-- can continue as if nothing happened
SUBCOMMIT;
COMMIT;
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Acepta los honores y aplausos y perderás tu libertad"
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
