[thelist] MySQL to PostgreSQL Conversion

Warren warren at digital-crossroads.com
Mon Apr 25 21:12:30 CDT 2005


I did some moving around and removed InnoDB and finally got the thing to 
work.  I have about 47 tables to convert. Thanks!

Judah McAuley wrote:

> My first guess would be the bit that says "ENGINE=InnoDB". InnoDB is 
> an sql engine specific to MySql. As far as I know Postgres doesn't 
> have InnoDB as an engine option. So try removing that bit and see what 
> Postgres has to say.
>
> Judah
>
> Warren Murray wrote:
>
>> 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