Re: BUG #1527: select retrieves 0 rows after vacuum analyze - Mailing list pgsql-bugs

From Michael Fuhr
Subject Re: BUG #1527: select retrieves 0 rows after vacuum analyze
Date
Msg-id 20050307165742.GA28093@winnie.fuhr.org
Whole thread Raw
In response to BUG #1527: select retrieves 0 rows after vacuum analyze  ("Theo Petersen" <tpetersen@ocv.com>)
List pgsql-bugs
On Mon, Mar 07, 2005 at 09:11:49AM -0700, Theo Petersen wrote:
>
> I had been running 7.4.7, and I'm back to 7.3.9 now so as to keep my db
> working when I restore a backup.  Is there any plan to address this in 7.4?

I don't think so:

http://archives.postgresql.org/pgsql-bugs/2004-06/msg00057.php

You should be able to work around it by setting oprcanhash to false
for the operator in question, although I never tested that extensively.

http://archives.postgresql.org/pgsql-general/2004-04/msg00461.php
http://archives.postgresql.org/pgsql-general/2004-04/msg00463.php

The problem is fixed in 8.0, so you might want to consider trying
8.0.1.  Among other things, it has an improved PL/Perl that might
have been handy on that project a year ago.  See the Release Notes
if you haven't been keeping up with it:

http://www.postgresql.org/docs/8.0/interactive/release-8-0.html
http://www.postgresql.org/docs/8.0/interactive/release.html#RELEASE-8-0-1

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-bugs by date:

Previous
From: Hans-Jürgen Schönig
Date:
Subject: Re: BUG #1519: server closed the connection unexpectedly
Next
From: Robert Treat
Date:
Subject: Re: [pgsql-www] Likely typo in FAQ_DEV.html