I am using a user-defined datatype in tables that I wish to export using Jailer. Unfortunately I get the error message "Column, parameter, or variable #2: Cannot specify a column width on data type SurrogateKey".
The docs for sp_addtype suggest that a column width cannot be specified on a user-defined datatype.
I wasn't able to find a related issue in the Tracker, nor the Forums; is this a known issue and is there a workaround please?
You seem to have CSS turned off.
Please don't fill out this field.
Although a later search turned up jailer_2.7.1.beta2.zip as containing a fix for a similar problem, I can't find that file.
I'm sorry, but there is currently no support for user-defined datatypes. Feel free to open a feature request for that issue.
As a workaraound you can modify the primary key column definitions in the file "datamodel/table.cvs" manually after the analysis of the database schema. Remove all column-width specifications on user-defined datatypes. For example, remove the "(<n>)" in each "SurrogateKey(<n>)" type definition.
I also have this issue in Jailer 4.0.13. Did you come across a resolution?
Sign up for the SourceForge newsletter: