From c7d0bc58c1a38042f88e68d12eb845fcfb7df4c0 Mon Sep 17 00:00:00 2001 From: Gregor Kleen Date: Thu, 5 May 2022 23:54:42 +0200 Subject: surtr: ... --- hosts/surtr/postgresql.nix | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'hosts/surtr') 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 { BEGIN; SELECT _v.register_patch('001-lmtp-mapping', ARRAY['000-base'], null); - 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; + 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; COMMIT; ''} ''; -- cgit v1.2.3