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

From: "Adam Rich" <adam(dot)r(at)sbcglobal(dot)net>
To: "'David Gagnon'" <david(dot)gagnon(at)cesart(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unable to add a new column to a table named "in" (look like a bug ...)
Date: 2008-04-17 14:15:10
Message-ID: 01d601c8a095$77a7dc40$66f794c0$@r@sbcglobal.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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")

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey 2008-04-17 14:23:00 Re: PostgresSQL on a networked drive with multiple users
Previous Message Terry Lee Tucker 2008-04-17 14:03:41 Duplicate Symbols - Compiler Warnings