Re: using NOLOCK cause Cartesian joins - Mailing list pgsql-general

From Greg Stark
Subject Re: using NOLOCK cause Cartesian joins
Date
Msg-id 87k765pcp8.fsf@stark.dyndns.tv
Whole thread Raw
In response to using NOLOCK cause Cartesian joins  ("Roger Gordon" <Roger@emojo.com>)
List pgsql-general
"Roger Gordon" <Roger@emojo.com> writes:

> When we use WITH (NOLOCK) at the end of table list in a SELECT query, a
> Cartesian join is returned (i.e. approximately  6,500 records instead of
> 57, which is distressing.

You'll have to post an actual query and output, preferably with an "explain
analyze" before anyone can help much. I certainly don't see this problem.

--
greg

pgsql-general by date:

Previous
From: Christopher Murtagh
Date:
Subject: pl/perl function life and variable scope - concurrency problem?
Next
From: Stephan Szabo
Date:
Subject: Re: using NOLOCK cause Cartesian joins