Hi Adam,
It worked Thanks!! But there is definitly something wrong with the error
message I got (right?):
reference=# alter table "IN" add column INDESCS VARCHAR[];
ERROR: column "indescs" of relation "IN" already exists
Anyway I can workaround with what you gave me.
Thanks again
David
-----Message d'origine-----
De : pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] De la part de Adam Rich
Envoyé : Thursday, April 17, 2008 10:15 AM
À : 'David Gagnon'; pgsql-general@postgresql.org
Objet : Re: [GENERAL] Unable to add a new column to a table named "in" (look
like a bug ...)
> 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")
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general