Column name 'user' not allowed?

From: Thomas Mueller <news-exp-dec04(at)tmueller(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Column name 'user' not allowed?
Date: 2004-07-07 20:43:52
Message-ID: pan.2004.07.07.20.43.50.597030@tmueller.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Diogo Biazus 2004-07-07 21:05:19 ERROR: missing chunk number 0 for toast value 14227980
Previous Message Ron St-Pierre 2004-07-07 20:33:03 FATAL: the database system is in recovery mode