Postgres Pro
Downloads
Home   >   mailing lists

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

From Mengelbier, Magnus
Subject parser: parse error at or near... with create table
Date
Msg-id 81F0C610BC68D2118F110008C7242DE51EAB58@luex1.clinicaldatacare.com
Whole thread Raw
Responses Re: [INTERFACES] parser: parse error at or near... with create table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
Tree view 
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

pgsql-interfaces by date:

Previous
From: "Collin F. Lynch"
Date:
Subject: libpgtcl.so.2.0
Next
From: Thomas Lockhart
Date:
Subject: Re: [INTERFACES] libpgtcl.so.2.0