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

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@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")
>
>
>
>