[ppa-help] [phppgadmin - Help] Can't create a table

[SourceForge.net <no...@so...>]

Read and respond to this message at: 
https://sourceforge.net/forum/message.php?msg_id=2536106
By: lorriman

PostgreSQL 7.2.1 
phpPgAdmin 3.3.1 

Trying to create a table via phppgadmin (not my own sql). I get the message :

SQL error:
ERROR:  parser: parse error at or near "("

In statement:
CREATE TABLE "personaddress" ("ID" SERIAL(4) NOT NULL, "PersonID" integer(4)
NOT NULL, "Address1" character varying(50), "Address2" character varying(50),
"Address3" character varying(50), "District" character varying(50), "Country"
character varying(50), "Postcode" character varying(20), "Tel1" character
varying(30), "Tel2" character varying(30), "Created" timestamp with time zone
NOT NULL, "Modified" timestamp with time zone NOT NULL)

Any ideas? I am a newbie on postgres, BTW. 

Thanks, Greg

______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit: 
https://sourceforge.net/forum/unmonitor.php?forum_id=115884