Re: [BUGS] BUG #4166: Alter table add column from PgAdminIII

2008-05-14 Thread Tom Lane
"Mike Gagnon" <[EMAIL PROTECTED]> 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 g

Re: [BUGS] BUG #4166: Alter table add column from PgAdminIII

2008-05-14 Thread Heikki Linnakangas
Mike Gagnon wrote: 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

[BUGS] BUG #4166: Alter table add column from PgAdminIII

2008-05-14 Thread Mike Gagnon
The following bug has been logged online: Bug reference: 4166 Logged by: Mike Gagnon Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1-1 Operating system: Windows XP Description:Alter table add column from PgAdminIII Details: Hi Postgres Experts, I used PGA