Re: Unable to add a new column to a table named "in" (look like a bug ...)

Поиск
Список
Период
Сортировка
От Adam Rich
Тема Re: Unable to add a new column to a table named "in" (look like a bug ...)
Дата
Msg-id 01d601c8a095$77a7dc40$66f794c0$@r@sbcglobal.net
обсуждение исходный текст
Ответ на Unable to add a new column to a table named "in" (look like a bug ...)  ("David Gagnon" <david.gagnon@cesart.com>)
Ответы Re: Unable to add a new column to a table named "in" (look like a bug ...)
Список pgsql-general
> Could you just have a look to the output below?  I try to add a column
> to a
> table named "in" (I know "in" is a reserved keyword but the table
> exists and
> I cannot change it).  Postgresql complains that the column already
> exist but
> it didn't.  Am I doing something wrong ?

Try:  ALTER TABLE "in" add column INDESCS VARCHAR[];

(note the double quotes and lower-case "in")



В списке pgsql-general по дате отправления:

Предыдущее
От: "David Gagnon"
Дата:
Сообщение: Unable to add a new column to a table named "in" (look like a bug ...)
Следующее
От: "David Gagnon"
Дата:
Сообщение: Re: Unable to add a new column to a table named "in" (look like a bug ...)