Thanks Mike, your post from about a year ago correctly identifies the
problem. (And you correctly identified the app too.)

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?

Regards,
Theo Petersen

-----Original Message-----
From: Michael Fuhr [mailto:mike (AT) fuhr (DOT) org]
Sent: Friday, March 04, 2005 11:20 PM
To: Theo Petersen; pgsql-bugs (AT) postgresql (DOT) org
Cc: Tom Lane
Subject: Re: [BUGS] BUG #1527: select retrieves 0 rows after vacuum analyze

"Theo Petersen" <tpetersen (AT) ocv (DOT) com> writes:
Are you perchance doing joins involving INET or CIDR types where
the old database is 7.3.x and the new database is 7.4.x? I ask
because I discovered a problem with the 7.4.x = operator when I was
(hastily) writing the prototype for the application I think you're
working on.

http://archives.postgresql.org/pgsql...4/msg00453.php

If this is the problem you're having, then it should be mentioned
on the project Wiki that Chris F. set up, if it still exists.

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly