From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: Mengelbier, Magnus <Magnus.Mengelbier@clinicaldatacare.com>
Cc: 'pgsql-interfaces@postgresql.org' <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] parser: parse error at or near... with create table
Date: Fri, 30 Jul 1999 15:29:37 +0000
Message-ID: <37A1C4E1.F56DED39@alumni.caltech.edu> (raw)
References: <81F0C610BC68D2118F110008C7242DE51EAB58@luex1.clinicaldatacare.com>
> We wonder if any one has experience from an error (which is probably a
> newbie misstake on our part) that pops up when we are trying to create a
> simple table with pgAccess in a postgreSQL database. We have recieved the
> same type of error on more complex table builds. The message is ...
> Error executing query
> create table "asdfs" ("fds" serial NOT NULL )
> PostgreSQL error message:
> Error: parser: parse error at or near "not"
> PostgreSQL status: PGRES_FATAL_ERROR
By definition, the SERIAL type is NOT NULL, so I didn't bother
allowing that clause in the parser. If you would like to see this
feature documented, send patches on docs/src/sgml/datatype.sgml. Or
maybe we should allow it, but it *is* redundant ;)
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: lockhart@alumni.caltech.edu, Magnus.Mengelbier@clinicaldatacare.com
Subject: Re: [INTERFACES] parser: parse error at or near... with create table
In-Reply-To: <37A1C4E1.F56DED39@alumni.caltech.edu>
* 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