From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
---|---|
To: | "Thomas Mueller" <news-exp-dec04(at)tmueller(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Column name 'user' not allowed? |
Date: | 2004-07-07 21:22:34 |
Message-ID: | 54798A299E68514AB7C4DEBA25F03BE101BB1B@postal.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
See:
http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html
Try "UserName"
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of
> Thomas Mueller
> Sent: Wednesday, July 07, 2004 1:44 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Column name 'user' not allowed?
>
>
> Hi,
>
> I tried to install phpopenchat but I can't create this table:
>
> poc=> CREATE TABLE poc_user_account (
> poc(> USER varchar(255) NOT NULL,
> poc(> PASSWORD varchar(255),
> poc(> CONFIRM_CODE char(32),
> poc(> DISABLED int NOT NULL DEFAULT '0',
> poc(> KICKED int NOT NULL DEFAULT '0',
> poc(> PASSWORD_NEW varchar(255),
> poc(> PRIMARY KEY (USER)
> poc(> );
> ERROR: syntax error at or near "USER" at character 35
>
> After searching a while what's wrong I renamed column USER to
> USER2 and now I can create the table! I don't see a reason
> why column name USER isn't allowed?!
>
> I am running Postgres 7.4.2 on Linux.
>
> Thanks!
>
>
> Thomas
> --
> http://www.tmueller.com for pgp key (95702B3B)
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | MargaretGillon | 2004-07-07 21:27:27 | Re: Error in postgreSQL |
Previous Message | Stephan Szabo | 2004-07-07 21:19:37 | Re: Column name 'user' not allowed? |