Re: Wrong rows selected with view

Bill Moseley <moseley(at)hank(dot)org> writes:
> On Wed, Nov 16, 2005 at 10:53:21AM -0500, Tom Lane wrote:
>> Bizarre. What are the datatypes of the columns being joined on? If
>> they're string types, what's your database locale and encoding?

> The primary keys are all SERIAL, and the FKs are integer. Nothing too
> odd.

Well, that eliminates the theory I had, which was that string comparison
was messing up because of incompatible locale/encoding choices.

I think you may have found a PG bug. Can you duplicate the misbehavior
if you dump the data and reload it into a fresh database? (Note you'll
probably need to re-ANALYZE to get back to the same query plans.) If
so, would you be willing to send me the dump off-list? If the data is
not too sensitive, this'd probably be easier than trying to find a
smaller test case.

regards, tom lane