"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: nicoanto||Date: 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 Linnakangas||Date: 2008-05-14 08:18:37|
|Subject: Re: BUG #4166: Alter table add column from PgAdminIII|