apgdiff
apgdiff copied to clipboard
Missing constriant on add
The beginning of the script removes the constraint company_type_con which is:
CHECK ((((((company_type = 'ltd'::text) OR (company_type = 'part'::text)) OR (company_type = 'sole'::text)) OR (company_type = 'charity'::text)) OR (company_type = 'church'::text)))
It attempts to readd the constraint with:
ADD CONSTRAINT company_type_con CHECK ((((company_type = 'ltd'::text) OR (company_type = 'part'::text)) OR (company_type = 'sole'::text)));
Evidently the obscene amount of brackets is causing the problem.