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