diff options
| author | Gregor Kleen <gkleen@yggdrasil.li> | 2022-12-16 20:43:49 +0100 |
|---|---|---|
| committer | Gregor Kleen <gkleen@yggdrasil.li> | 2022-12-16 20:43:49 +0100 |
| commit | 46da3eed283b4a7b4f0153db025e7dbecd67b6a5 (patch) | |
| tree | 565a08c1cf923a54754db6010e5cbd31f21ebbb5 /hosts/surtr/postgresql | |
| parent | 3a0d7137658dfa40f5d2ef09869160b03f0409a4 (diff) | |
| download | nixos-46da3eed283b4a7b4f0153db025e7dbecd67b6a5.tar nixos-46da3eed283b4a7b4f0153db025e7dbecd67b6a5.tar.gz nixos-46da3eed283b4a7b4f0153db025e7dbecd67b6a5.tar.bz2 nixos-46da3eed283b4a7b4f0153db025e7dbecd67b6a5.tar.xz nixos-46da3eed283b4a7b4f0153db025e7dbecd67b6a5.zip | |
...
Diffstat (limited to 'hosts/surtr/postgresql')
| -rw-r--r-- | hosts/surtr/postgresql/default.nix | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/hosts/surtr/postgresql/default.nix b/hosts/surtr/postgresql/default.nix index 9cfcc365..891b6ce0 100644 --- a/hosts/surtr/postgresql/default.nix +++ b/hosts/surtr/postgresql/default.nix | |||
| @@ -228,7 +228,6 @@ 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 UNIQUE USING INDEX local_domain_unique; | ||
| 232 | 231 | ||
| 233 | CREATE UNIQUE INDEX local_extension_domain_unique ON mailbox_mapping (local, extension, domain); | 232 | CREATE UNIQUE INDEX local_extension_domain_unique ON mailbox_mapping (local, extension, domain); |
| 234 | ALTER TABLE mailbox_mapping ADD CONSTRAINT local_extension_domain_unique UNIQUE USING INDEX local_extension_domain_unique; | 233 | ALTER TABLE mailbox_mapping ADD CONSTRAINT local_extension_domain_unique UNIQUE USING INDEX local_extension_domain_unique; |