parser: parse error at or near... with create table

Hello all !

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

We are running ...

- PostgreSQL 6.5.1 on Red Hat Linux 6.0 ... we installed binaries downloaded
from posgresql.org and not compiled source code.

- pgAccess 0.96 on the same Red Hat Linux system as well as a Win95
computer. Win95 has tcl/tk 8.0 installed.

Thanks !

Magnus

________________________________________________________
Magnus Mengelbier
Technical Consultant
Clinical Data Care
S:t Lars v. 41
SE-222 70 LUND
SWEDEN
Phone +46 46 14 22 80
Fax +46 46 13 04 90
Email magnus(dot)mengelbier(at)clinicaldatacare(dot)com
Web http://www.clinicaldatacare.com