summaryrefslogtreecommitdiff
path: root/hosts/surtr/postgresql
diff options
context:
space:
mode:
authorGregor Kleen <gkleen@yggdrasil.li>2022-12-18 19:11:49 +0100
committerGregor Kleen <gkleen@yggdrasil.li>2022-12-18 19:11:49 +0100
commitaffd561853323be51b4bef9c8a9841e7b90899ce (patch)
tree894405ec10e1982d1405e5cd85bd15a8975b7340 /hosts/surtr/postgresql
parent2b92f10ae5dab7c78718db4b701e866ac85d99cb (diff)
downloadnixos-affd561853323be51b4bef9c8a9841e7b90899ce.tar
nixos-affd561853323be51b4bef9c8a9841e7b90899ce.tar.gz
nixos-affd561853323be51b4bef9c8a9841e7b90899ce.tar.bz2
nixos-affd561853323be51b4bef9c8a9841e7b90899ce.tar.xz
nixos-affd561853323be51b4bef9c8a9841e7b90899ce.zip
...
Diffstat (limited to 'hosts/surtr/postgresql')
-rw-r--r--hosts/surtr/postgresql/default.nix6
1 files changed, 6 insertions, 0 deletions
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 {
242 242
243 GRANT UPDATE ON "mailbox_mapping" TO "spm"; 243 GRANT UPDATE ON "mailbox_mapping" TO "spm";
244 COMMIT; 244 COMMIT;
245
246 BEGIN;
247 SELECT _v.register_patch('010-spm-delete-mapping', ARRAY['000-base', '002-citext', '003-extensions'], null);
248
249 GRANT DELETE ON "mailbox_mapping" TO "spm";
250 COMMIT;
245 ''} 251 ''}
246 252
247 psql etebase postgres -eXf ${pkgs.writeText "etebase.sql" '' 253 psql etebase postgres -eXf ${pkgs.writeText "etebase.sql" ''