pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgres ERROR
3+ messages / 3 participants
[nested] [flat]

* Postgres ERROR
@ 1999-07-13 11:30 Esteban Chiner Sanz <echiner@tissat.es>
  1999-07-13 14:01 ` Re: [SQL] Postgres ERROR Tom Lane <tgl@sss.pgh.pa.us>
  1999-07-13 17:00 ` Re: [SQL] Postgres ERROR Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 2 replies; 3+ messages in thread

From: Esteban Chiner Sanz @ 1999-07-13 11:30 UTC (permalink / raw)
  To: pgsql-sql

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

Thank you,


            Esteban




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] Postgres ERROR
  1999-07-13 11:30 Postgres ERROR Esteban Chiner Sanz <echiner@tissat.es>
@ 1999-07-13 14:01 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 1999-07-13 14:01 UTC (permalink / raw)
  To: Esteban Chiner Sanz <echiner@tissat.es>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] Postgres ERROR
  1999-07-13 11:30 Postgres ERROR Esteban Chiner Sanz <echiner@tissat.es>
@ 1999-07-13 17:00 ` Bruce Momjian <maillist@candle.pha.pa.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Bruce Momjian @ 1999-07-13 17:00 UTC (permalink / raw)
  To: Esteban Chiner Sanz <echiner@tissat.es>; +Cc: pgsql-sql

> 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

VACUUM ANALYZE your table.  6.4 has problems with ALTER TABLE ADD COLUMN
and Alpha cpus.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~1999-07-13 17:00 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-07-13 11:30 Postgres ERROR Esteban Chiner Sanz <echiner@tissat.es>
1999-07-13 14:01 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-07-13 17:00 ` Bruce Momjian <maillist@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox