On 3/17/06, loki <[EMAIL PROTECTED]> wrote: > Hi, > i'm just starting with postgres DB, but this looks very strange to me: > > If i try to create table with collumn user, it fails with error: > create exec error:ERROR: syntax error at or near "user" at character 368 > > query: > CREATE TABLE Log ( > log_date date NOT NULL, > log_time time NOT NULL, > timezone int NOT NULL default 60 , > dest varchar(20) NOT NULL default 'messages', > hostname varchar(100) NOT NULL default 'localhost', > source varchar(20) NOT NULL default 'db_speed', > pid numeric(10) NOT NULL default 0 , > category int NOT NULL default 10 , > priority int NOT NULL default 10 , > user int NOT NULL default 0 , > log varchar(800) NOT NULL > ); > > But if I change the collumn name to "usr" (just this, nothing else), it > is o.k. and the table is created.
user is a reserved sql word: http://www.postgresql.org/docs/8.1/static/sql-keywords-appendix.html -- Postgresql & php tutorials http://www.designmagick.com/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
