From 3a0d7137658dfa40f5d2ef09869160b03f0409a4 Mon Sep 17 00:00:00 2001 From: Gregor Kleen Date: Fri, 16 Dec 2022 20:40:50 +0100 Subject: ... --- hosts/surtr/postgresql/default.nix | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/hosts/surtr/postgresql/default.nix b/hosts/surtr/postgresql/default.nix index 019ed3a5..9cfcc365 100644 --- a/hosts/surtr/postgresql/default.nix +++ b/hosts/surtr/postgresql/default.nix @@ -228,10 +228,10 @@ in { ALTER TABLE mailbox_mapping DROP CONSTRAINT local_domain_unique; CREATE UNIQUE INDEX local_domain_unique ON mailbox_mapping (local, domain) WHERE extension IS null; - ALTER TABLE mailbox_mapping ADD CONSTRAINT local_domain_unique USING INDEX local_domain_unique; + ALTER TABLE mailbox_mapping ADD CONSTRAINT local_domain_unique UNIQUE USING INDEX local_domain_unique; CREATE UNIQUE INDEX local_extension_domain_unique ON mailbox_mapping (local, extension, domain); - ALTER TABLE mailbox_mapping ADD CONSTRAINT local_extension_domain_unique USING INDEX local_extension_domain_unique; + ALTER TABLE mailbox_mapping ADD CONSTRAINT local_extension_domain_unique UNIQUE USING INDEX local_extension_domain_unique; ALTER TABLE mailbox_mapping ADD COLUMN reject bool NOT NULL DEFAULT false; -- cgit v1.2.3