News for hackers. Stuff that matters.
Re:MySQL to PostgreSQL converter by bjacobel on Saturday February 28, 2015 @09:34AM (#9123737)
No foreign key support is kind of a deal-breaker. Hard to believe anyone who is actually in the position of needing this would have a schema so simple that it contains no foreign keys.
Re:MySQL to PostgreSQL converter by maligree on Saturday February 28, 2015 @04:09PM (#9125074)
> so simple

or complex

Re:MySQL to PostgreSQL converter by warbiscuit on Saturday February 28, 2015 @09:42AM (#9123755)
Hard to believe mysql doesn't include that data in one of it's dump formats.
Re:MySQL to PostgreSQL converter by morgo on Saturday February 28, 2015 @09:45AM (#9123761)
It is supported, just not in XML dump format.
Re:MySQL to PostgreSQL converter by warbiscuit on Saturday February 28, 2015 @09:55AM (#9123793)
Ah. That's a relief, I was a little worried. But that makes it strange that someone, knowing of this limitation, would choose to start with the xml dump format.
Re:MySQL to PostgreSQL converter by barking on Saturday February 28, 2015 @10:10AM (#9123836)
I think the fact that this form of dump doesn't contain foreign keys is even more extraordinary.

What's the point of having a dump format that you can't use to restore your database properly?

Does it have a health warning advising that it's not a proper dump?

Re:MySQL to PostgreSQL converter by maaaats on Saturday February 28, 2015 @07:54PM (#9125634)
Well, I've had issues with pg_dump's standard format. It can't be directly used to restore a db, one must manually set it to dump a .bak or something else.
Re:MySQL to PostgreSQL converter by jeltz on Saturday February 28, 2015 @09:56PM (#9125869)
Not sure what you refer to here. All pg_dump formats should work for restoring a database. The only flaw in pg_dump that I know of is the mess if you want to dump an entire cluster of databases but still have one file per database.
Re:MySQL to PostgreSQL converter by danneu on Saturday February 28, 2015 @12:16PM (#9124293)
It contains the foreign key data, but not the constraint.

You get this:

    <field Field="course_id" Type="int(10)" Null="NO" Key="MUL"/>
But not this:

    CONSTRAINT `fk_courses_offered_class_details`
    FOREIGN KEY (`course_id`)
    REFERENCES `courses_offered` (`id`)
Re:MySQL to PostgreSQL converter by chris_wot on Saturday February 28, 2015 @10:03AM (#9123823)
How?