Skip to content
This repository has been archived by the owner on May 10, 2023. It is now read-only.

Autogenerated index name length exceeds 63 characters #77

Open
deep9 opened this issue Jan 7, 2015 · 0 comments
Open

Autogenerated index name length exceeds 63 characters #77

deep9 opened this issue Jan 7, 2015 · 0 comments

Comments

@deep9
Copy link

deep9 commented Jan 7, 2015

When migrating, indexes are created with autogenerated name in Writer. PG has a limit of column (and index) name to 63 characters, so when you have first 63 characters of generated index equal for some indexes, you get an error while importing.

psql:/projects/mysql_2_pg.sql:8093973: ERROR:  cannot drop index X because constraint X on table Y requires it
HINT:  You can drop constraint X on table Y instead.
psql:/projects/mysql_2_pg.sql:8093974: ERROR:  relation "X" already exists

Can you have an option to just re-use index names from current database? Or any other thoughts on this?

Thanks.

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

No branches or pull requests

1 participant