Postgres Pro
Downloads
Home   >   mailing lists

Select for update with outer join broken? - Mailing list pgsql-hackers

From Josh Berkus
Subject Select for update with outer join broken?
Date
Msg-id 200609301212.29547.josh@agliodbs.com
Whole thread Raw
Responses Re: Select for update with outer join broken?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
All,

Some change which was made in the last couple weeks broke select for update
with an outer join:

Please examine the SQLException for more information.
NestedException: org.postgresql.util.PSQLException: ERROR: SELECT FOR  
UPDATE/SHARE cannot be applied to the nullable side of an outer join
         at  
com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.throwJDOSql
Exception(SQLStoreManager.java:632)

This was working per SQL spec before beta ... what happened?  Error above is
from Thursday's snapshot.

--
Josh Berkus
PostgreSQL @ Sun
San Francisco

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: libedit broke in head
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: libedit broke in head