Re: [SQL] Postgres ERROR

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [SQL] Postgres ERROR
Дата
Msg-id 22411.931874515@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Postgres ERROR  ("Esteban Chiner Sanz" <echiner@tissat.es>)
Список pgsql-sql
"Esteban Chiner Sanz" <echiner@tissat.es> writes:
> What does this error mean? I've look for it in the documentation but I
> haven't found it.
> ERROR: RestrictionClauseSelectivity: bad value -1.998611

Sounds like some bad data has gotten into your pg_statistic table.
You can probably fix the problem by running VACUUM ANALYZE.

What Postgres version are you running?  I recall hearing of someone
seeing that error with a buggy pre-alpha version, but not with any
production releases...
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: "D'Arcy" "J.M." Cain
Дата:
Сообщение: Re: [SQL] calculating percentages
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] "quoting" column names