From db535fc5efc4da170a2ee8bb74018ac042e7c186 Mon Sep 17 00:00:00 2001 From: Gregor Kleen Date: Sat, 7 Jun 2025 10:35:50 +0200 Subject: ... --- hosts/surtr/postgresql/default.nix | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'hosts/surtr/postgresql/default.nix') diff --git a/hosts/surtr/postgresql/default.nix b/hosts/surtr/postgresql/default.nix index 3640ff12..e29da0b8 100644 --- a/hosts/surtr/postgresql/default.nix +++ b/hosts/surtr/postgresql/default.nix @@ -297,7 +297,6 @@ in { COMMIT; - BEGIN; SELECT _v.register_patch('014-relay', ARRAY['000-base'], null); @@ -308,6 +307,13 @@ in { ); COMMIT; + + BEGIN; + SELECT _v.register_patch('015-relay-unique', ARRAY['000-base', '014-relay'], null); + + CREATE UNIQUE INDEX relay_unique ON relay_access (mailbox, domain); + + COMMIT; ''} psql etebase postgres -eXf ${pkgs.writeText "etebase.sql" '' -- cgit v1.2.3