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

strange error

From: ZioBudda <michel(at)michel(dot)enter(dot)it>
To: pgsql-general(at)postgreSQL(dot)org
Subject: strange error
Date: 1999-01-19 21:34:25
Message-ID: Pine.LNX.4.05.9901192233160.503-100000@michel.enter.it (view raw or flat)
Thread:
Lists: pgsql-general
I don't know if this mailing list is the appropriate ML, but:
I think that in postgresql 6.3.2 there is a little bug.
I have a table. I exec:
alter table my_table add column mycolumn mytype\g
now if I make a select on this new column I get this error

ERROR:  RestrictionClauseSelectivity: bad value 2.350645

Otherwise, if I drop the my_table and recreate my_table with the new
column all 
is work. Why this ?

And again another question. I drop my_table. I re-create my_Table with
this comm
and:
www=> create table sito (url varchar(255) PRIMARY KEY,
www-> titolo varchar(255), note varchar(64), indicazioni varchar(50),
genere int
,visto int, titolo_down varchar(255));\g

and psql return me:
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index sito_pkey for
table
 sito
CREATE
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index sito_pkey for
table
 sito
ERROR:  amcreate: sito relation already exists

why the error?

tnx


"Non è importante che tu sia crotalo o pavone, l'importante è che
se tu muori me lo dici prima". (Cèlv)
--
Michel <ZioBudda> Morelli		  michel(at)michel(dot)enter(dot)it
					http://ziobudda.enter.it
Problemi con Linux ?    mailto:linux(at)saturn(dot)media(dot)dsi(dot)unimi(dot)it


Responses

pgsql-general by date

Next:From: Bruce MomjianDate: 1999-01-19 23:00:33
Subject: Re: [GENERAL] strange error
Previous:From: Peter T MountDate: 1999-01-19 21:16:50
Subject: Re: [GENERAL] Access database from PostgreSQL?

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