why don't this create table work?

From: User & <marc(at)oscar(dot)noc(dot)cv(dot)net>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: why don't this create table work?
Date: 1999-11-02 22:59:15
Message-ID: 19991102175915.A80511@oscar.noc.cv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Rugge 1999-11-03 02:51:52 timestamps
Previous Message Tom Lane 1999-11-02 19:09:58 Re: [SQL] Redhat 6.0 Link Error: Undefined Reference to crypt