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

Re: BUG #4166: Alter table add column from PgAdminIII

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mike Gagnon" <mike(dot)gagnon(at)bellnet(dot)ca>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4166: Alter table add column from PgAdminIII
Date: 2008-05-14 14:34:09
Message-ID: 19213.1210775649@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Mike Gagnon" <mike(dot)gagnon(at)bellnet(dot)ca> writes:
> I used PGAdmin III to add a character varying column(400) length, not null
> default ''.  I get the column displayed in psql when I do a simple query
> like SELECT * from MyTable limit 1;

> When I try to do Update MyTable set NewColumn='something';   I get the error
> saying that the column doesn't exist....

I'm betting you have a case sensitivity problem.  Either you created the
column as "NewColumn" with quotes and are trying to reference it without
quotes, or vice versa.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: nicoantoDate: 2008-05-14 14:40:18
Subject: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows
Previous:From: Heikki LinnakangasDate: 2008-05-14 08:18:37
Subject: Re: BUG #4166: Alter table add column from PgAdminIII

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