Re: [HACKERS] MERGE SQL Statement for PG11 - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [HACKERS] MERGE SQL Statement for PG11
Date
Msg-id 20180403032240.mkpdgowco7sjrq6f@alap3.anarazel.de
Whole thread Raw
In response to Re: [HACKERS] MERGE SQL Statement for PG11  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Hi,

On 2018-04-02 19:40:12 -0700, Peter Geoghegan wrote:
> > So what happens if there's a concurrent insertion of a potentially
> > matching tuple?
> 
> It's not a special case. In all likelihood, you get a dup violation.
> This is a behavior that I argued for from an early stage.

Right. I think that should be mentioned in the comment...

Greetings,

Andres Freund


pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [HACKERS] MERGE SQL Statement for PG11
Next
From: Peter Geoghegan
Date:
Subject: Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS