Re: Atomic operations?

On 18-Mar-08, at 7:18 PM, Oliver Jowett wrote:

> Dave Cramer wrote:
>> On 18-Mar-08, at 9:40 AM, Paul Tomblin wrote:
>
>>>  PreparedStatement ps = conn.prepareStatement(
>>>     "DELETE FROM venue WHERE venueid = ? ; INSERT INTO VENUE
>>> (venueid, .... ) VALUES(?, ?, ?, ?)");
>
>>> Does that work?  Will that be atomic so that nobody else can insert
>>> one with that venueid in between the delete and the insert?
>>>
>> I don't think so,
>
> Actually it's fine the implicit transaction created by the server to
> support autocommit wraps both queries in a single transaction and
> does not commit/rollback until the end of the second query.
>
Yeah, using v3 protocol this is presented as one prepare/execute.
Thanks for catching that.
> -O
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc