apgdiff icon indicating copy to clipboard operation
apgdiff copied to clipboard

Missing constriant on add

Open dylwylie opened this issue 10 years ago • 0 comments

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.

dylwylie avatar Aug 06 '14 12:08 dylwylie