Re: [INTERFACES] parser: parse error at or near... with create table - Mailing list pgsql-interfaces

> 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