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
