Re: PREPARE and transactions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PREPARE and transactions
Date
Msg-id 13817.1088087194@sss.pgh.pa.us
Whole thread Raw
In response to Re: PREPARE and transactions  ("Jeroen T. Vermeulen" <jtv@xs4all.nl>)
Responses [Re] Re: PREPARE and transactions
Re: PREPARE and transactions
List pgsql-hackers
"Jeroen T. Vermeulen" <jtv@xs4all.nl> writes:
> I think we're talking at cross purposes here...  If the client doesn't use
> explicit transactions, as you say is common, then you're obviously not
> defining prepared statements inside explicit transactions either.

This whole discussion seems to be considering only the case of PREPAREs
issued as SQL statements, by a programmer who is fully cognizant of
where he's beginning and ending transactions.

The issue I was trying to raise at the beginning of the thread was: what
about prepared statements created by client libraries (think JDBC for
instance) using the V3 protocol Parse message?  Rolling back a
successful prepare because of a later transaction failure seems like
exactly not what such a library would want.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jeroen T. Vermeulen"
Date:
Subject: Re: PREPARE and transactions
Next
From: "Thomas Hallgren"
Date:
Subject: Re: warning missing