Comment 3 for bug 1569884

Revision history for this message
Mike Rylander (mrylander) wrote :

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;

Thanks, Dan!