From affd561853323be51b4bef9c8a9841e7b90899ce Mon Sep 17 00:00:00 2001
From: Gregor Kleen <gkleen@yggdrasil.li>
Date: Sun, 18 Dec 2022 19:11:49 +0100
Subject: ...

---
 hosts/surtr/postgresql/default.nix | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'hosts')

diff --git a/hosts/surtr/postgresql/default.nix b/hosts/surtr/postgresql/default.nix
index b9086e73..f0edfbac 100644
--- a/hosts/surtr/postgresql/default.nix
+++ b/hosts/surtr/postgresql/default.nix
@@ -242,6 +242,12 @@ in {
 
           GRANT UPDATE ON "mailbox_mapping" TO "spm";
           COMMIT;
+
+          BEGIN;
+          SELECT _v.register_patch('010-spm-delete-mapping', ARRAY['000-base', '002-citext', '003-extensions'], null);
+
+          GRANT DELETE ON "mailbox_mapping" TO "spm";
+          COMMIT;
         ''}
 
         psql etebase postgres -eXf ${pkgs.writeText "etebase.sql" ''
-- 
cgit v1.2.3