On Sat, Jun 26, 2004 at 09:12:33AM -0400, Merlin Moncure wrote: > > BEGIN; > > ... do something ... ; > > SUBBEGIN; > > EXECUTE ...; > > -- if it fails: > > -- SUBABORT; > > -- PREPARE ...; > > -- SUBBEGIN; > > -- EXECUTE ...; > > -- can continue as if nothing happened > > SUBCOMMIT; > > COMMIT; > > This is not an option: this requires that every EXECUTE be wrapped with > a subtransaction. This is a performance killer because it (at minimum) > triples my statement turnaround latency.
Ah, good point. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "Linux transformó mi computadora, de una `máquina para hacer cosas', en un aparato realmente entretenido, sobre el cual cada día aprendo algo nuevo" (Jaime Salinas) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
