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  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Re: BUG #4166: Alter table add column from PgAdminIII  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: BUG #4162: Hotbackup recovery doesn't work in windows
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: BUG #4166: Alter table add column from PgAdminIII