Received: from oscar.noc.cv.net (oscar.noc.cv.net [167.206.113.20]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA54048 for ; Tue, 2 Nov 1999 18:03:32 -0500 (EST) (envelope-from marc@oscar.noc.cv.net) Received: (from marc@localhost) by oscar.noc.cv.net (8.9.3/8.9.3) id RAA81079 for pgsql-sql@postgreSQL.org; Tue, 2 Nov 1999 17:59:15 -0500 (EST) (envelope-from marc) Date: Tue, 2 Nov 1999 17:59:15 -0500 From: User & To: pgsql-sql@postgreSQL.org Subject: why don't this create table work? Message-ID: <19991102175915.A80511@oscar.noc.cv.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre3i 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