3 ALTER TABLE serial.issuance DROP CONSTRAINT IF EXISTS issuance_caption_and_pattern_fkey;
5 -- Using NOT VALID and VALIDATE CONSTRAINT limits the impact to concurrent work.
6 -- For details, see: https://www.postgresql.org/docs/current/static/sql-altertable.html
8 ALTER TABLE serial.issuance ADD CONSTRAINT issuance_caption_and_pattern_fkey
9 FOREIGN KEY (caption_and_pattern)
10 REFERENCES serial.caption_and_pattern (id)
12 DEFERRABLE INITIALLY DEFERRED
15 ALTER TABLE serial.issuance VALIDATE CONSTRAINT issuance_caption_and_pattern_fkey;