From: | Duane Lee - EGOVX <DLee(at)mail(dot)maricopa(dot)gov> |
---|---|
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:35:16 |
Message-ID: | 64EDC403A1417B4299488BAE87CA7CBF01CD0EB7@maricopa_xcng0 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Try putting USER in quotes like this "USER".
-----Original Message-----
From: Thomas Mueller [mailto:news-exp-dec04(at)tmueller(dot)com]
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 | Chris Smith | 2004-07-07 21:40:24 | Re: ERROR: missing chunk number 0 for toast value 14227980 |
Previous Message | MargaretGillon | 2004-07-07 21:27:27 | Re: Error in postgreSQL |