Re: Weird prepared stmt behavior - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Weird prepared stmt behavior
Date
Msg-id 20040504020250.GA602@dcc.uchile.cl
Whole thread Raw
In response to Re: Weird prepared stmt behavior  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-hackers
On Tue, May 04, 2004 at 01:22:53AM -0000, Greg Sabino Mullane wrote:

> What about rolling prepares back if they are in a transaction, though?
> They still have the ability to affect a transaction, despite being
> partially outside of it:

> [example ripped]

IMHO this is an oversight, not a design feature.  That's why I pointed
it out and planned to correct it.

I think with the Prepare message we should _not_ abort the transaction
if it fails -- if it's outside transaction control, it shouldn't affect
the current transaction (So we would open a subtransaction, process the
message, and rollback if it fails.)

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La fuerza no está en los medios físicos
sino que reside en una voluntad indomable" (Gandhi)


pgsql-hackers by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: Weird prepared stmt behavior
Next
From: Tom Lane
Date:
Subject: Re: Weird prepared stmt behavior