Re: Query returning tuples that does not satisfy the WHERE clause

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Query returning tuples that does not satisfy the WHERE clause
Date: 2006-09-08 18:42:48
Message-ID: 21539.1157740968@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx> writes:
> I don't think so, search_path has its default value and also I'm able
> to reproduce it in a fresh cluster (tried 3 different machines to
> discard hardware problems).

Hm, well I'm willing to take a look if you can provide me access to the
problem database running on a debug-enabled Postgres build. The
fresh-cluster test seems to rule out my other idea about a corrupt
index (though that was shaky anyway considering both plans use the
same index...)

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-09-08 18:55:12 Re: Fixed length data types issue
Previous Message Alvaro Herrera 2006-09-08 18:39:03 Re: Fixed length data types issue