diff options
Diffstat (limited to 'hosts')
-rw-r--r-- | hosts/surtr/postgresql/default.nix | 6 |
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" '' |