summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGregor Kleen <gkleen@yggdrasil.li>2022-12-16 20:40:50 +0100
committerGregor Kleen <gkleen@yggdrasil.li>2022-12-16 20:40:50 +0100
commit3a0d7137658dfa40f5d2ef09869160b03f0409a4 (patch)
treec6a6ca166288985fbea953c341e0e56b3dbf831c
parent3409d4a9128bff673ebb3638ec3dc37ad10a3010 (diff)
downloadnixos-3a0d7137658dfa40f5d2ef09869160b03f0409a4.tar
nixos-3a0d7137658dfa40f5d2ef09869160b03f0409a4.tar.gz
nixos-3a0d7137658dfa40f5d2ef09869160b03f0409a4.tar.bz2
nixos-3a0d7137658dfa40f5d2ef09869160b03f0409a4.tar.xz
nixos-3a0d7137658dfa40f5d2ef09869160b03f0409a4.zip
...
-rw-r--r--hosts/surtr/postgresql/default.nix4
1 files 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 {
228 228
229 ALTER TABLE mailbox_mapping DROP CONSTRAINT local_domain_unique; 229 ALTER TABLE mailbox_mapping DROP CONSTRAINT local_domain_unique;
230 CREATE UNIQUE INDEX local_domain_unique ON mailbox_mapping (local, domain) WHERE extension IS null; 230 CREATE UNIQUE INDEX local_domain_unique ON mailbox_mapping (local, domain) WHERE extension IS null;
231 ALTER TABLE mailbox_mapping ADD CONSTRAINT local_domain_unique USING INDEX local_domain_unique; 231 ALTER TABLE mailbox_mapping ADD CONSTRAINT local_domain_unique UNIQUE USING INDEX local_domain_unique;
232 232
233 CREATE UNIQUE INDEX local_extension_domain_unique ON mailbox_mapping (local, extension, domain); 233 CREATE UNIQUE INDEX local_extension_domain_unique ON mailbox_mapping (local, extension, domain);
234 ALTER TABLE mailbox_mapping ADD CONSTRAINT local_extension_domain_unique USING INDEX local_extension_domain_unique; 234 ALTER TABLE mailbox_mapping ADD CONSTRAINT local_extension_domain_unique UNIQUE USING INDEX local_extension_domain_unique;
235 235
236 ALTER TABLE mailbox_mapping ADD COLUMN reject bool NOT NULL DEFAULT false; 236 ALTER TABLE mailbox_mapping ADD COLUMN reject bool NOT NULL DEFAULT false;
237 237