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

Alter Table Bug

From: Sezai Yilmaz <sezaiy(at)ata(dot)cs(dot)hun(dot)edu(dot)tr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Alter Table Bug
Date: 1999-05-02 15:33:35
Message-ID: Pine.LNX.4.04.9905021832550.3129-100000@ata.cs.hun.edu.tr (view raw or flat)
Thread:
Lists: pgsql-bugs
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





Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 1999-05-02 17:09:52
Subject: Re: [BUGS] Alter Table Bug
Previous:From: Sezai YILMAZDate: 1999-04-30 12:17:46
Subject: Alter Table Bug

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