Re: BUG #13769: SELECT ... FROM a JOIN b FOR UPDATE a; BREAKS SNAPSHOT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: konst583(at)mail(dot)ru
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13769: SELECT ... FROM a JOIN b FOR UPDATE a; BREAKS SNAPSHOT
Date: 2015-11-11 15:23:43
Message-ID: 28810.1447255423@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

konst583(at)mail(dot)ru writes:
> Select of 2-nd transaction will return new value from a and old value from
> b

That's what FOR UPDATE is designed to do. If you don't like it, use
serializable mode.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message jhirsch 2015-11-11 15:48:02 Re: BUG #13622: unsafe use of relative rpath libpq.5.dylib
Previous Message konst583 2015-11-11 15:10:04 BUG #13769: SELECT ... FROM a JOIN b FOR UPDATE a; BREAKS SNAPSHOT