Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mysql column type enum not supported #16

Open
ppet opened this issue Apr 19, 2016 · 2 comments
Open

mysql column type enum not supported #16

ppet opened this issue Apr 19, 2016 · 2 comments

Comments

@ppet
Copy link

ppet commented Apr 19, 2016

Hello, I try a migration from mysql 5.6 to postgres 9.5. There is a column of type "enum" in the mysql table schema which is not supported.
<CREATE TABLE activity ( idactivity INT, type VARCHAR( 100), object_model ENUM( 13), object_id INT, created_at timestamp, created_by INT, updated_at timestamp, updated_by INT, commentaire TEXT ) >
org.postgresql.util.PSQLException: ERROR: type "enum" does not exist

Do you have a workaround ?

Thx for your help
Philippe

@ppet
Copy link
Author

ppet commented Apr 19, 2016

I have another proposition: why don't you provide a generated sql file we could enhance or correct in case of failure of the command passed to the targeted base ?
cheers

@luiscamposflores
Copy link
Contributor

Hello, enum was never tested! I'll do a simple test and try to implement it. Give me a couple of days.
The option to generate a SQL file could be done, but the main focus is to migrate databases, fast, the schema generation is just one part. But I believe is not hard to get that output.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants