Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] parser: parse error at or near... with create table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mengelbier, Magnus" <Magnus(dot)Mengelbier(at)clinicaldatacare(dot)com>
Cc: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] parser: parse error at or near... with create table
Date: 1999-07-30 15:40:18
Message-ID: 11385.933349218@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
"Mengelbier, Magnus" <Magnus(dot)Mengelbier(at)clinicaldatacare(dot)com> writes:
> 	Error executing query
> 	create table "asdfs" ("fds" serial   NOT NULL )
> 	PostgreSQL error message:
> 		Error: parser: parse error at or near "not"

Hmm.  NOT NULL is implied by SERIAL column type, so you can just omit
that clause, but it's irritating that the parser won't accept the
explicit specification.  It looks like the grammar is set up to allow
no column constraints except PRIMARY KEY after SERIAL.  That seems
unnecessarily restrictive...

			regards, tom lane

pgsql-interfaces by date

Next:From: Mark BedishDate: 1999-07-30 16:30:50
Subject: unsubscribe
Previous:From: Tom LaneDate: 1999-07-30 15:31:17
Subject: Re: [INTERFACES] libpgtcl.so.2.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group