From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Sezai Yilmaz <sezaiy(at)ata(dot)cs(dot)hun(dot)edu(dot)tr> |
Cc: | pgsql-bugs(at)postgreSQL(dot)org |
Subject: | Re: [BUGS] Alter Table Bug |
Date: | 1999-05-02 17:09:52 |
Message-ID: | 199905021709.NAA05577@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
This is fixed in the current tree. Do a vacuum analyze on the table,
and it will be ok.
>
> Your name : Sezai YILMAZ
> Your email address : sezaiy(at)hacettepe(dot)edu(dot)tr
>
>
> System Configuration
> ---------------------
> Architecture (example: Intel Pentium) : intel Pentium II 350Mhz
>
> Operating System (example: Linux 2.0.26 ELF) : Linux 2.0.36 ELF
>
> PostgreSQL version (example: PostgreSQL-6.4.2): PostgreSQL-6.4.2
>
> Compiler used (example: gcc 2.8.0) : gcc 2.7.2.3
>
>
> Please enter a FULL description of your problem:
> ------------------------------------------------
>
> I modified a table of a postgres database by using SQL command alter
> table. My modification only consists of adding a new column which
> type is char(20) to the existing table. After that, I began to update
> that column by inserting string values to whole column:
>
> update table1 set new_column='something';
>
> After that I tried to select all records whose new_column field is set to
> 'something'.
>
> select * from table1 where new_column='something';
>
> And the error message produced by the postgres follows:
>
> ERROR: RestrictionClauseSelectivity: bad value 2.456940
>
> When I backup the database and drop and create the table1 with the
> 'new_column' there is no problem with selecting the records which match to
> the search criteria.
>
> FYI
>
> Sezai YILMAZ
> User Support Group,
> Computer Center,
> Hacettepe University
>
> Voice: +90 312 2976200 - +90 312 2352500/1209
> Fax : +90 312 2992088
>
>
>
>
>
>
--
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
From | Date | Subject | |
---|---|---|---|
Next Message | Unprivileged user | 1999-05-03 11:18:13 | General Bug Report: pg_dump sets quotes wrong when dumping groups-acls. |
Previous Message | Sezai Yilmaz | 1999-05-02 15:33:35 | Alter Table Bug |