diff options
| author | Gregor Kleen <gkleen@yggdrasil.li> | 2022-05-05 19:38:46 +0200 |
|---|---|---|
| committer | Gregor Kleen <gkleen@yggdrasil.li> | 2022-05-05 19:38:46 +0200 |
| commit | 3c5a3ac95b84c2f263afcd2b5952dc29f517955d (patch) | |
| tree | fa8aeb50dd684301b362e7c86e6ce2aa6efface7 /hosts/surtr/postgresql.nix | |
| parent | 5340096101e67892ca3229bd8a235847c6e7384b (diff) | |
| download | nixos-3c5a3ac95b84c2f263afcd2b5952dc29f517955d.tar nixos-3c5a3ac95b84c2f263afcd2b5952dc29f517955d.tar.gz nixos-3c5a3ac95b84c2f263afcd2b5952dc29f517955d.tar.bz2 nixos-3c5a3ac95b84c2f263afcd2b5952dc29f517955d.tar.xz nixos-3c5a3ac95b84c2f263afcd2b5952dc29f517955d.zip | |
...
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 0529a0f2..798857f5 100644 --- a/hosts/surtr/postgresql.nix +++ b/hosts/surtr/postgresql.nix | |||
| @@ -35,7 +35,7 @@ in { | |||
| 35 | mailbox text NOT NULL CONSTRAINT mailbox_non_empty CHECK (mailbox <> '''), | 35 | mailbox text NOT NULL CONSTRAINT mailbox_non_empty CHECK (mailbox <> '''), |
| 36 | quota_bytes bigint CONSTRAINT quota_bytes_positive CHECK (CASE WHEN quota_bytes IS NOT NULL THEN quota_bytes > 0 ELSE true END), | 36 | quota_bytes bigint CONSTRAINT quota_bytes_positive CHECK (CASE WHEN quota_bytes IS NOT NULL THEN quota_bytes > 0 ELSE true END), |
| 37 | quota_rule text GENERATED ALWAYS AS (CASE WHEN quota_bytes IS NULL THEN '*:ignore' ELSE '*:bytes=' || quota_bytes END) STORED | 37 | quota_rule text GENERATED ALWAYS AS (CASE WHEN quota_bytes IS NULL THEN '*:ignore' ELSE '*:bytes=' || quota_bytes END) STORED |
| 38 | ) | 38 | ); |
| 39 | CREATE TABLE mailbox_mapping ( | 39 | CREATE TABLE mailbox_mapping ( |
| 40 | id uuid PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(), | 40 | id uuid PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(), |
| 41 | local text CONSTRAINT local_non_empty CHECK (local IS DISTINCT FROM '''), | 41 | local text CONSTRAINT local_non_empty CHECK (local IS DISTINCT FROM '''), |