Skip site navigation (1) Skip section navigation (2)

Select for update with outer join broken?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Select for update with outer join broken?
Date: 2006-09-30 19:12:29
Message-ID: 200609301212.29547.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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

Responses

pgsql-hackers by date

Next:From: Stefan KaltenbrunnerDate: 2006-09-30 19:14:30
Subject: Re: libedit broke in head
Previous:From: Tom LaneDate: 2006-09-30 19:00:57
Subject: Re: libedit broke in head

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group