"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