Re: [INTERFACES] ERROR: RestrictionClauseSelectivity: bad value -1.998477

From: Stefan Hornburg <racke(at)gundel(dot)han(dot)de>
To: Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] ERROR: RestrictionClauseSelectivity: bad value -1.998477
Date: 1999-02-03 15:20:12
Message-ID: m3hft3a503.fsf@gundel.han.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Dirk Lutzebaeck <lutzeb(at)aeccom(dot)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.

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 1999-02-03 16:42:01 Re: [INTERFACES] Postgres Limitations
Previous Message Byron Nikolaidis 1999-02-03 14:45:41 Re: [INTERFACES] LinuxODBC