search

dataegret / pgcompacttable

BSD 3-Clause "New" or "Revised" License
314 stars 48 forks source link

recreating constraints missing deferrable #4

Closed opb1978 closed 7 years ago

opb1978 commented 8 years ago

We have noticed that the script is not respecting all settings of original constraints.

In our case we use DEFERRABLE with a constraint after using the script deferrable was gone.

ALTER TABLE ONLY lot -ADD CONSTRAINT ukey_lot UNIQUE (street_id, city_id, zip_id, housenumber, block, staircase) DEFERRABLE; +ADD CONSTRAINT ukey_lot UNIQUE (street_id, city_id, zip_id, housenumber, block, staircase);

In our case we actually did not need deferrable but the script should respect all original settings

Melkij commented 7 years ago

Hi I fixed this error in #10 and today PR was merged to master.