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

[Rodrigo Gonzalez]

Are you sure?

\d "IN"

Let us know if you have OTHER table called IN.



David Gagnon escribió:

When you use quotes you are making them case sensitive, so "in" != "IN" != "In" etc, etc

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 : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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")

smime.p7s
Description: S/MIME Cryptographic Signature