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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
