Re: Select For Update and Left Outer Join - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Select For Update and Left Outer Join
Date
Msg-id 4E1AE805020000250003F1BA@gw.wicourts.gov
Whole thread Raw
In response to Re: Select For Update and Left Outer Join  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> wrote:
> I'm wondering if it wouldn't make sense to dodge all that by
> having SELECT FOR UPDATE simple *do* a no-op UPDATE RETURNING.
Hmm.
Patrick, would it be possible to change the PostgreSQL code for
Hibernate to use UPDATE RETURNING instead of SELECT FOR UPDATE? 
That might allow portable Hibernate applications to work properly
with recent PostgreSQL versions without going to SERIALIZABLE
transactions.
-Kevin


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Launching debugger on self on SIGSEGV
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Full GUID support