Skip site navigation (1) Skip section navigation (2)

Re: Atomic operations?

From: "Paul Tomblin" <ptomblin(at)gmail(dot)com>
To: "Dave Cramer" <pg(at)fastcrypt(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Atomic operations?
Date: 2008-03-18 15:05:35
Message-ID: 8efd35820803180805k4649991atfa1e515b044bf815@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
On Tue, Mar 18, 2008 at 10:17 AM, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
>  >> On 18-Mar-08, at 9:40 AM, Paul Tomblin wrote:
>  >>> I'm doing a simple delete/insert on a table, rather than trying to
>  >>> figure out whether the row exists or not and then doing an update or
>  >>> an insert.  But what I'm discovering is that every now and then I

>  >> Can't you just check the return value from the delete to see if
>  >> anything was deleted ?
>  >
>  > I'm not sure how that would help.  If I do the delete and it didn't
>  > delete anything, that doesn't tell me if some other process inserted
>  > it in the meantime.
>  >
>  which ever process succeeds in deleting should do the insert.

Doesn't help in the case where the record wasn't in there in the first place.

-- 
For my assured failures and derelictions I ask pardon beforehand of my
betters and my equals in my Calling here assembled, praying that in
the hour of my temptations, weakness and weariness, the memory of this
my Obligation and of the company before whom it was entered into, may
return to me to aid, comfort and restrain.

In response to

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2008-03-18 15:28:39
Subject: Re: Atomic operations?
Previous:From: Dave CramerDate: 2008-03-18 14:25:57
Subject: Re: setQueryTimeout problem !?!?!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group