[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [HACKERS] Select for update with outer join broken?
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2006-09-30 19:21:17
Message-ID: 15881.1159644077 () sss ! pgh ! pa ! us
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]