Josh Berkus <[email protected]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster