aboutsummaryrefslogtreecommitdiff
path: root/sqitch/deploy/remove_guix_revisions_store_path.sql
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2021-02-02 23:36:56 +0000
committerChristopher Baines <mail@cbaines.net>2021-02-02 23:36:56 +0000
commit7fbcb3a3c26906ee130bcc64e88ea7a2b390de2c (patch)
tree1b1f55d68015f18fabea46865c3762a61d150691 /sqitch/deploy/remove_guix_revisions_store_path.sql
parent6195d7b18f913d0f8f5540858676b7d6c45196b7 (diff)
downloaddata-service-7fbcb3a3c26906ee130bcc64e88ea7a2b390de2c.tar
data-service-7fbcb3a3c26906ee130bcc64e88ea7a2b390de2c.tar.gz
Store channel instance derivations in a separate transaction
This means that these derivations are stored, even if a later part of the process fails. Having the channel instance derivations stored might help work out why the failure occurred, or better display information about it.
Diffstat (limited to 'sqitch/deploy/remove_guix_revisions_store_path.sql')
-rw-r--r--sqitch/deploy/remove_guix_revisions_store_path.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/deploy/remove_guix_revisions_store_path.sql b/sqitch/deploy/remove_guix_revisions_store_path.sql
new file mode 100644
index 0000000..aaec02b
--- /dev/null
+++ b/sqitch/deploy/remove_guix_revisions_store_path.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-data-service:remove_guix_revisions_store_path to pg
+
+BEGIN;
+
+ALTER TABLE guix_revisions DROP COLUMN store_path;
+
+COMMIT;