From: | loki <loigu(at)centrum(dot)cz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | can't create user collumn |
Date: | 2006-03-17 11:26:12 |
Message-ID: | 441A9CD4.8040609@centrum.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
The question is, if I omit something, or it is a 'feature' of postgres,
or if it is a bug?
Thanks
Jiri Zouhar
p.s. I have postgres (PostgreSQL) 8.0.7, RH FC4 build
From | Date | Subject | |
---|---|---|---|
Next Message | Zvonimir Radek | 2006-03-17 12:54:38 | each line counter |
Previous Message | SunWuKung | 2006-03-17 10:16:35 | pgsql variables from records |