diff options
| author | Gregor Kleen <gkleen@yggdrasil.li> | 2022-05-05 23:54:42 +0200 |
|---|---|---|
| committer | Gregor Kleen <gkleen@yggdrasil.li> | 2022-05-05 23:54:42 +0200 |
| commit | c7d0bc58c1a38042f88e68d12eb845fcfb7df4c0 (patch) | |
| tree | a6c43da20a43ef84a64498d2eaaa1e1491c9d648 /hosts/surtr/postgresql.nix | |
| parent | c0391046dc0d4859841c56788d53fb37c7e84e15 (diff) | |
| download | nixos-c7d0bc58c1a38042f88e68d12eb845fcfb7df4c0.tar nixos-c7d0bc58c1a38042f88e68d12eb845fcfb7df4c0.tar.gz nixos-c7d0bc58c1a38042f88e68d12eb845fcfb7df4c0.tar.bz2 nixos-c7d0bc58c1a38042f88e68d12eb845fcfb7df4c0.tar.xz nixos-c7d0bc58c1a38042f88e68d12eb845fcfb7df4c0.zip | |
surtr: ...
Diffstat (limited to 'hosts/surtr/postgresql.nix')
| -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 | ''; |