SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join

Поиск
Список
Период
Сортировка
От James Robinson
Тема SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join
Дата
Msg-id B15DF97D-188F-4FD1-99B6-BCEB7E0C3E99@socialserve.com
обсуждение исходный текст
Ответы Re: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Given something like:
create table foo (id int primary key not null);create table bar (id int primary key not null, a_id int references  
foo(id));select a.id, b.id from foo a left outer join bar b on (b.a_id =  
a.id) for update;

PG 8.1.4 balks, saying:

SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an  
outer join

Is this behavior spec-mandated, or could only the rows in B which are  
not-null be locked?

----
James Robinson
Socialserve.com



В списке pgsql-sql по дате отправления:

Предыдущее
От: Graham Davis
Дата:
Сообщение: Re: [HACKERS] timestamp subtraction (was Re: formatting intervals
Следующее
От: Tom Lane
Дата:
Сообщение: Re: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join