[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