Re: [BUGS] BUG #6608: SELECT FOR UPDATE not obtaining row exclusive locks in CTEs

2012-04-25 Thread Tom Lane
duncan.bu...@orionvm.com.au writes: > I found that running a SELECT FOR UPDATE query in a CTE does not block > simultaneous transactions from running the same query. The reason this test case doesn't do anything: > CREATE FUNCTION lock_0(int) returns int as $$ > WITH locked as ( > SEL

[BUGS] BUG #6608: SELECT FOR UPDATE not obtaining row exclusive locks in CTEs

2012-04-23 Thread duncan . burke
The following bug has been logged on the website: Bug reference: 6608 Logged by: Duncan Burke Email address: duncan.bu...@orionvm.com.au PostgreSQL version: 9.1.3 Operating system: gentoo Description: I found that running a SELECT FOR UPDATE query in a CTE does not bl