philipsoutham / py-mysql2pgsql

Tool for migrating/converting from mysql to postgresql.
http://packages.python.org/py-mysql2pgsql/
MIT License
455 stars 169 forks source link

Primary key handling #31

Closed rupa108 closed 11 years ago

rupa108 commented 11 years ago

In order to get the tool to convert my database I had to make some minor adjustments to the way primary keys are handled. I think they might be of general interest so please consider to include them in upstream.

1) The type of primary keys should be maintained instead of setting to integer. This is important when there are self referencing foreign keys. 2) The definition of primary keys has multiple blanks in my Version of MySQL.

Regards