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

From: James Robinson <jlrobins(at)socialserve(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join
Date: 2006-10-06 15:31:47
Message-ID: B15DF97D-188F-4FD1-99B6-BCEB7E0C3E99@socialserve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2006-10-06 16:25:23 Re: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join
Previous Message Graham Davis 2006-10-06 15:05:04 Re: [HACKERS] timestamp subtraction (was Re: formatting intervals