Re: PREPARE and transactions - Mailing list pgsql-hackers

From Abhijit Menon-Sen
Subject Re: PREPARE and transactions
Date
Msg-id 20040703082017.G1473@lustre.dyn.wiw.org
Whole thread Raw
In response to Re: [Re] Re: PREPARE and transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PREPARE and transactions  (Abhijit Menon-Sen <ams@oryx.com>)
Re: PREPARE and transactions  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: PREPARE and transactions  ("Jeroen T. Vermeulen" <jtv@xs4all.nl>)
List pgsql-hackers
At 2004-06-24 13:13:42 -0400, tgl@sss.pgh.pa.us wrote:
>
> > This is why I proposed originally to keep the non-transactional
> > behavior for Parse messages, but transactional for SQL PREPARE.
> > The latter can be said to be inside the transaction and should
> > behave like so.  I think this lowers the surprise factor.
>
> It seems like we are closing in on an agreement that that is what
> should happen.

As a client maintainer, I have no particular problem with the status quo
(apparently like Greg and Cyril), but I can appreciate the point made in
Jeroen's initial post in this thread, and I would not object to changing
PREPARE to be transactional while leaving Parse messages alone. Nor do I
have a problem with "PREPARE OR REPLACE".

But for what it's worth, I strongly dislike the later proposal of making
prepared statements anonymous, and pattern matching the statement text,
especially if they reintroduce the need to quote query parameters.

Ugh.

-- ams


pgsql-hackers by date:

Previous
From: "Jeroen T. Vermeulen"
Date:
Subject: Re: [Re] Re: PREPARE and transactions
Next
From: Tom Lane
Date:
Subject: Re: Adding column comment to information_schema.columns