From: User & <marc@oscar.noc.cv.net>
To: pgsql-sql@postgreSQL.org
Subject: why don't this create table work?
Date: Tue, 2 Nov 1999 17:59:15 -0500
Message-ID: <19991102175915.A80511@oscar.noc.cv.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: marc@oscar.noc.cv.net
Subject: Re: why don't this create table work?
In-Reply-To: <19991102175915.A80511@oscar.noc.cv.net>
References: <19991102175915.A80511@oscar.noc.cv.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox