| From: | marc(at)oscar(dot)noc(dot)cv(dot)net (User &) |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | why don't this create table work? |
| Date: | 1999-11-02 08:38:37 |
| Message-ID: | slrn81t8gf.1ttk.marc@oscar.noc.cv.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
here is the sql:
nnm=> create table nnm_event_limits (
nnm-> nodename varchar(256) not null,
nnm-> event_oid varchar(256) not null,
nnm-> always_never varchar(1) null,
nnm-> limit int4);
ERROR: parser: parse error at or near "null"
This is converted from openviews table scheema. here it is without the
trailing null on always_never:
nnm=> create table nnm_event_limits (
nnm-> nodename varchar(256) not null,
nnm-> event_oid varchar(256) not null,
nnm-> always_never varchar(1) ,
nnm-> limit int4);
ERROR: parser: parse error at or near "limit"
limit is not a reserved word as far as I can tell, any ideas?
I am useing 6.5, got it from PG_VERSION file.
I am new to DB programming in general and Postgres in particular.
Thanks Marc
ps would useing text instead of varchar be a good thing to do?
Marc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 1999-11-02 09:20:33 | Re: [GENERAL] users in Postgresql |
| Previous Message | Roomi | 1999-11-02 07:17:57 | ERROR: btree: lost page |