Dan Wells spotted a mistake of mine. We'll want a unique index ... so:
ALTER TABLE biblio.monograph_part DROP CONSTRAINT "record_label_unique";
CREATE UNIQUE INDEX CONCURRENTLY record_label_unique_idx ON biblio.monograph_part (record, label) WHERE deleted = FALSE;
Dan Wells spotted a mistake of mine. We'll want a unique index ... so:
ALTER TABLE biblio. monograph_ part DROP CONSTRAINT "record_ label_unique" ; label_unique_ idx ON biblio. monograph_ part (record, label) WHERE deleted = FALSE;
CREATE UNIQUE INDEX CONCURRENTLY record_
Thanks, Dan!