Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Select for update with outer join broken?
Date
Msg-id 11941.1159806950@sss.pgh.pa.us
Whole thread Raw
In response to Re: Select for update with outer join broken?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Select for update with outer join broken?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Tree view 
Josh Berkus <josh@agliodbs.com> writes:
> Oh, no, what should happen is that the outer join portion of the query doesn't 
> get locked, rather than a fatal exception.  That behavior is expected by the 
> J2EE certification, so it's at least somewhat industry-standard.

Really?  Please cite chapter and verse.  And why should it be that the
unmatched outer-side rows don't get locked (which is what I think you
just said)?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Select for update with outer join broken?
Next
From: Simon Riggs
Date:
Subject: Re: [BUGS] Update using sub-select table in schema