BUG #4166: Alter table add column from PgAdminIII
От | Mike Gagnon |
---|---|
Тема | BUG #4166: Alter table add column from PgAdminIII |
Дата | |
Msg-id | 200805140205.m4E25cv2015285@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #4166: Alter table add column from PgAdminIII
Re: BUG #4166: Alter table add column from PgAdminIII |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 4166 Logged by: Mike Gagnon Email address: mike.gagnon@bellnet.ca PostgreSQL version: 8.3.1-1 Operating system: Windows XP Description: Alter table add column from PgAdminIII Details: Hi Postgres Experts, 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.... It thinks it exists when I do my select, but it doesn't recognize this new column in my UPDATE... I'm scared... I have a deadline coming up and I'm praying this one gets fixed soon. Many thanks! Mike
В списке pgsql-bugs по дате отправления: