Skip site navigation (1) Skip section navigation (2)

Re: [BUGS] Alter Table Bug

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 (view raw or flat)
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

In response to

pgsql-bugs by date

Next:From: Unprivileged userDate: 1999-05-03 11:18:13
Subject: General Bug Report: pg_dump sets quotes wrong when dumping groups-acls.
Previous:From: Sezai YilmazDate: 1999-05-02 15:33:35
Subject: Alter Table Bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group