Are you sure? \d "IN" Let us know if you have OTHER table called IN.When you use quotes you are making them case sensitive, so "in" != "IN" != "In" etc, etc
David Gagnon escribió:
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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] De la part de Adam Rich Envoyé : Thursday, April 17, 2008 10:15 AM À : 'David Gagnon'; pgsql-general@xxxxxxxxxxxxxx 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")
<<attachment: smime.p7s>>
