Re: [HACKERS] INSERT...ON DUPLICATE KEY LOCK FOR UPDATE - visibility semantics

2013-09-27 Thread Peter Geoghegan
On Tue, Sep 24, 2013 at 2:14 AM, Andres Freund wrote: > Various messages are discussing semantics around visibility. I by now > have a hard time keeping track. So let's keep the discussion of the > desired semantics to this thread. Yes, it's pretty complicated. I meant to comment on this here, b

Re: [HACKERS] INSERT...ON DUPLICATE KEY LOCK FOR UPDATE - visibility semantics

2013-09-24 Thread Robert Haas
On Tue, Sep 24, 2013 at 5:14 AM, Andres Freund wrote: > Various messages are discussing semantics around visibility. I by now > have a hard time keeping track. So let's keep the discussion of the > desired semantics to this thread. > > There have been some remarks about serialization failures in r

Re: [HACKERS] INSERT...ON DUPLICATE KEY LOCK FOR UPDATE - visibility semantics

2013-09-24 Thread Andres Freund
Hi, Various messages are discussing semantics around visibility. I by now have a hard time keeping track. So let's keep the discussion of the desired semantics to this thread. There have been some remarks about serialization failures in read committed transactions. I agree, those shouldn't occur.