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 happenedSUBCOMMIT;
COMMIT;
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Acepta los honores y aplausos y perderás tu libertad"