diff options
Diffstat (limited to 'hosts/surtr')
| -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" '' |
