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.mengelbier@clinicaldatacare.com
Web    http://www.clinicaldatacare.com