Josh Berkus <josh@agliodbs.com> writes: > Some change which was made in the last couple weeks broke select for update > with an outer join:
> NestedException: org.postgresql.util.PSQLException: ERROR: SELECT FOR > UPDATE/SHARE cannot be applied to the nullable side of an outer join What SQL query is it complaining about, exactly? That error message has been there right along, but I seem to recall having moved the place where it's checked for since 8.1. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings