Re: [INTERFACES] ERROR: RestrictionClauseSelectivity: bad value -1.998477 - Mailing list pgsql-interfaces

From Stefan Hornburg
Subject Re: [INTERFACES] ERROR: RestrictionClauseSelectivity: bad value -1.998477
Date
Msg-id m3hft3a503.fsf@gundel.han.de
Whole thread Raw
In response to ERROR: RestrictionClauseSelectivity: bad value -1.998477  (Stefan Hornburg <racke@gundel.han.de>)
List pgsql-interfaces
Dirk Lutzebaeck <lutzeb@aeccom.com> writes:

> Stefan Hornburg writes:
>
>  > The above error lurks in my Apache logs. I'm totally puzzled about the
>  > cause. I'm trying to use authentification from a Postgres database with:
>
> I have seen this also. Find out the table, copy it, drop the old one,
> rename it. This worked for me. Take care of oid references to your
> records in your table.
>
> Dirk
>

After searching the archives, it seems that it is indeed a PostgreSQL
problem. A better workaround is to issue the SQL statement
"VACUUM ANALYZE".

Ciao    Racke

--
LinuXia - Solutions of Cool Competence - Internetprogramming and more
D-30163 Hannover, Waldstraße 4, 0511-393656 (Coming soon: www.linuxia.de)
Come to the land of real computing where penguins and their friends
spreading the word of Open Source which crushes windows instantly.

pgsql-interfaces by date:

Previous
From: Andreas Kaschke
Date:
Subject: subscribe
Next
From: Peter T Mount
Date:
Subject: Re: Large object error in postgresql 6.4.2 sparc solaris