Postgres Pro
Downloads
Home   >   mailing lists

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

From Heikki Linnakangas
Subject Re: Select For Update and Left Outer Join
Date
Msg-id 4E1A8CFB.5050402@enterprisedb.com
Whole thread Raw
In response to Re: Select For Update and Left Outer Join  (Patrick Earl <patearl@patearl.net>)
Responses Re: Select For Update and Left Outer Join
List pgsql-hackers
Tree view 
On 11.07.2011 05:45, Patrick Earl wrote:
> The ability to lock on outer joins is quite useful.  I've even been
> contacted to ask if I was aware of any progress in this area.

9.1 has a truly serializable isolation level, so I would suggest using 
that instead of SELECT FOR UPDATE.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Darren Duncan
Date:
Subject: Re: [GENERAL] Creating temp tables inside read only transactions
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [BUGS] make_greater_string() does not return a string in some cases