Hola Alvaro On Tue, 17 Aug 2004 16:58:56 -0400, Alvaro Herrera Munoz <[EMAIL PROTECTED]> wrote: > > On Wed, 11 Aug 2004 11:47:35 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > > > The other objection is that this would create very substantial overhead. > > > > why? > > Establishing a savepoint is a non-trivial operation (cost-wise). Several > internal server structures have to be prepared for it. It's way cheaper than > normal transaction start and commit, but undesirable anyway if done once per > query. Worse if it's going to be seldom used.
I see. So, any heavy use of savepoints, say, issuing one before each SQL command that might violate a restriction, would worsen a lot the performance of my application? Saludos Haroldo -- Por favor registre [EMAIL PROTECTED] como mi nueva y unica direccion de correo en lugar de la vieja [EMAIL PROTECTED] Please, record [EMAIL PROTECTED] as my new and unique email address instead of ye old [EMAIL PROTECTED] Gracias. Thankyou. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])