Postgres Pro
Downloads
Home   >   mailing lists

why can't select for update be used with join - Mailing list pgsql-admin

From Kris Kiger
Subject why can't select for update be used with join
Date
Msg-id 3FA94CDC.1090309@musicrebellion.com
Whole thread Raw
In response to performance problem - 10.000 databases  (Marek Florianczyk <franki@tpi.pl>)
Responses Re: why can't select for update be used with join  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
I'm trying to do a query:  select ta.x from ta join tb using (y) where z
= 'somevalue' FOR UPDATE

Why can't this be executed without error in 7.3.x?  It worked just fine
in 7.2.x.   Thanks for the input

pgsql-admin by date:

Previous
From: Marek Florianczyk
Date:
Subject: Re: performance problem - 10.000 databases
Next
From: Tom Lane
Date:
Subject: Re: why can't select for update be used with join