| From: | Mike Mascari <mascarm(at)mascari(dot)com> |
|---|---|
| To: | Peter Darley <pdarley(at)kinesis-cem(dot)com> |
| Cc: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>, Mark Harrison <mh(at)pixar(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: most idiomatic way to "update or insert"? |
| Date: | 2004-08-05 13:50:46 |
| Message-ID: | 41123B36.6050909@mascari.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Peter Darley wrote:
> Lincoln, It works for me... I think what you said is wrong
> because it updates first (if there is a row to update), then
> inserts. If there is a row to update the insert won't insert
> anything. If there is no row to update the insert inserts a row.
> Either way, the insert is the last thing in the transaction.
> Plus, as shown in the code to follow, I have almost this exact
> thing in my application and I know that it does work for me. :)
You're getting lucky. I suggested the same thing four years ago. The
race condition is still there:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=2344.978158285%40sss.pgh.pa.us
HTH,
Mike Mascari
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2004-08-05 13:52:33 | Re: most idiomatic way to "update or insert"? |
| Previous Message | Cott Lang | 2004-08-05 13:45:47 | PG over NFS tips |