Bill Moseley <moseley@xxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
