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
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 |