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

Better support for uncommon and/or vendor-specific data types #17

Open
bluerogue251 opened this issue Dec 1, 2017 · 0 comments
Open

Comments

@bluerogue251
Copy link
Owner

bluerogue251 commented Dec 1, 2017

I'm opening this issue to see how much demand there is for support for uncommon and/or vendor-specific data types.

Right now certain data types cause the program to error out. There is a workaround available for this by using the --excludeColumns option to exclude the problematic columns from subsetting, then handle them manually outside of the DBSubsetter program. However, this is not a great user experience, so the fewer users that have to resort to this kind of workaround, the better.

Examples of data types which are known not to be supported at this time are Postgres money, Postgres user-defined enums, and Postgres arrays of user-defined enums. We would likely find even more problematic data types if we tested custom data types in MySQL and SQL Server more thoroughly.

Related Automated Tests:

If you would like such a feature please add a 👍 to this issue, and feel free to leave any specific notes about your use case in this thread.

bluerogue251 added a commit that referenced this issue Jan 4, 2020
Use Postgres COPY feature for faster Postgres inserts (at least some of the time -- this only appears to make a difference in certain cases but not others, reasons still poorly understood).

Incidentally addresses at least some of #17 for Postgres
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant