[thelist] MySQL to PostgreSQL Conversion

Warren Murray warren at digital-crossroads.com
Mon Apr 25 13:53:35 CDT 2005


What's wrong with this SQL Statement in the my conversion from MySQL to 
PostgreSQL?

DROP TABLE "tblattachment";
CREATE TABLE "tblattachment" (
  "A_ID" varchar(38) NOT NULL default '',
  "A_Parent" varchar(38) NOT NULL default '',
  "A_Classification" INT4 default '0',
  "A_Releasability" varchar(65) default NULL,
  "A_Type" varchar(65) default NULL,
  "A_Name" varchar(65) NOT NULL default '',
  "A_Description" varchar(255) default NULL,
  "A_Content" longblob,
  "A_Owner" varchar(38) NOT NULL default '',
  "A_DateUpdated" datetime default NULL,
  PRIMARY KEY  ("A_ID"),
  CREATE INDEX "A_Parent" ON TABLE ("A_Parent")
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

It fails with this error: "ERROR:  syntax error at or near "CREATE" at 
character 509";

Thanks!

Warren


More information about the thelist mailing list