SELECT for UPDATE and outer join?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: SELECT for UPDATE and outer join?
Date: 2005-08-11 15:43:12
Message-ID: 200508110843.12819.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Folks,

------------------------------
SQL statement<select t0.po_number, t0.po_site_id, t0.po_supp_id,
t1.pol_number,
t1.pol_po_id, t1.pol_balance, t1.pol_qty, t1.pol_p_id, t1.pol_message,
t1.pol_de
ldate from  s_purchase_order t0  left outer join s_purchase_orderline
t1  on t0.
po_number = t1.pol_po_id   where t0.po_number = ? for update > with
input values
:java.lang.Integer:30239.
Please examine the SQLException for more information.
NestedException: java.sql.SQLException: ERROR: SELECT FOR UPDATE cannot
be applied to the nullable side of an outer join
-----------------------------

So, my question is: why can't we apply FOR UPDATE to an outer join? Is this
defined in the SQL Spec?

--
Josh Berkus
Aglio Database Solutions
San Francisco

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-08-11 18:17:30 Re: Determining return type of polymorphic function
Previous Message Martijn van Oosterhout 2005-08-11 15:33:31 Determining return type of polymorphic function