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...6/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...4/msg00461.php
http://archives.postgresql.org/pgsql...4/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/i...lease-8-0.html
http://www.postgresql.org/docs/8.0/i...#RELEASE-8-0-1

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend