Re: Re: Why is unique constraint needed for upsert? (treat atomicity as optional)

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: Why is unique constraint needed for upsert? (treat atomicity as optional)
Date: 2014-07-23 23:09:32
Message-ID: 53D040AC.8020106@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/23/2014 3:58 PM, Seamus Abshere wrote:
> Right - if you had a situation where that might happen, you would use
> a slightly more advanced version of the UPSERT command (and/or add a
> unique index).

a unique index wouldn't resolve the problem. without one, you'd end up
with two records, with one, you'd end up with an error.

naive programmers never seem to expect concurrency, its something that
just happens.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nick Guenther 2014-07-24 00:10:41 Re: Watching Views
Previous Message Jim Garrison 2014-07-23 23:00:21 Complex Recursive Query