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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2008-03-18 15:28:39 | Re: Atomic operations? |
Previous Message | Dave Cramer | 2008-03-18 14:25:57 | Re: setQueryTimeout problem !?!?! |