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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster