20190503_DDL_TAXA_ATTRIBUTE_TYPE_LENGTH SqlException

humlab-sead / sead_change_control

Sane SEAD change control using Sqitch.

1 stars 0 forks source link

20190503_DDL_TAXA_ATTRIBUTE_TYPE_LENGTH SqlException #101

Closed roger-mahler closed 5 years ago

roger-mahler commented 5 years ago

Import fails with exception "ERROR: value too long for type character varying(25)" when values are inserted into tbl_taxa_measured_attributes, column attribute_type.

Sample values that exceeeds 25 characters:

Length larva final (10th) instar
Length (brachypterous females)
Length female brachypterous
Length female macropterous
Length, head-end of elytra

visead commented 5 years ago

Suggest change column attribute_type to varchar(255) in SEAD

roger-mahler commented 5 years ago

Solved by increasing size of tbl_taxa_measured_attributes, column attribute_type to varchar(255).

Added as change request: CS_TAXA_20190503_ATTRIBUTE_TYPE_LENGTH