Re: [BUGS] Partial index causing wrong results to be returned on 8.1.3

2006-08-28 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > If it gives right answers after you increase work_mem sufficiently, > I'd bet on this one ... That's a good bet. Changing it from 1024 to 3500 did the trick ... only one row returned, even when using the index. Thanks very much! - -- Greg Sabino

Re: [BUGS] Partial index causing wrong results to be returned on 8.1.3

2006-08-28 Thread Tom Lane
Greg Sabino Mullane <[EMAIL PROTECTED]> writes: > I could not duplicate this on any identical database, but thought I > would report it here, just for completeness. I've tried reindexing, > vacuuming, etc. Explain plans all look normal. Possibly explained by this 8.1.4 fix? 2006-05-18 14:57 tgl