diff options
-rw-r--r-- | hosts/surtr/postgresql.nix | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/hosts/surtr/postgresql.nix b/hosts/surtr/postgresql.nix index 4899b972..bbe8d01b 100644 --- a/hosts/surtr/postgresql.nix +++ b/hosts/surtr/postgresql.nix | |||
@@ -54,7 +54,7 @@ in { | |||
54 | BEGIN; | 54 | BEGIN; |
55 | SELECT _v.register_patch('001-lmtp-mapping', ARRAY['000-base'], null); | 55 | SELECT _v.register_patch('001-lmtp-mapping', ARRAY['000-base'], null); |
56 | 56 | ||
57 | CREATE VIEW lmtp_mapping ("user", quota_rule, local, domain) AS SELECT mailbox.mailbox AS "user", (CASE WHEN quota_bytes IS NULL THEN '*:ignore' ELSE '*:bytes=' || quota_bytes END) AS quota_rule FROM mailbox INNER JOIN mailbox_mapping ON mailbox.id = mailbox_mapping.mailbox; | 57 | CREATE VIEW lmtp_mapping ("user", quota_rule, local, domain) AS SELECT mailbox.mailbox AS "user", (CASE WHEN quota_bytes IS NULL THEN '*:ignore' ELSE '*:bytes=' || quota_bytes END) AS quota_rule, local, domain FROM mailbox INNER JOIN mailbox_mapping ON mailbox.id = mailbox_mapping.mailbox; |
58 | COMMIT; | 58 | COMMIT; |
59 | ''} | 59 | ''} |
60 | ''; | 60 | ''; |