Re: [PORTS] Port Bug Report: ERROR:RestrictionClauseSelectivity: bad value 164739.656250

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Jeff MacDonald <jeff(at)hub(dot)org>
Cc: pgsql-ports(at)postgreSQL(dot)org
Subject: Re: [PORTS] Port Bug Report: ERROR:RestrictionClauseSelectivity: bad value 164739.656250
Date: 1999-07-09 16:49:39
Message-ID: 199907091649.MAA01355@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports

>
> jeff=> select * from psql_cds where mostrecent_sent=6.5;
> ERROR: RestrictionClauseSelectivity: bad value 164739.656250
>

Vacuum analyze the table. ALTER TABLE ADD COLUMN has messed things up.
Fixed in 6.5.

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

In response to

Browse pgsql-ports by date

  From Date Subject
Next Message Bruce Momjian 1999-07-09 16:57:26 Re: [PORTS] Above 2G on a 32 bit architecture
Previous Message Bruce Momjian 1999-07-09 16:42:52 Re: [PORTS] Port Bug Report: Command "CREATE TABLE AS with SELECT ... UNION" don't work