diff options
author | Christopher Baines <mail@cbaines.net> | 2019-12-05 14:09:28 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2019-12-05 15:41:51 +0100 |
commit | 3457d5f6a648ba62b581be4d80be95e60f3c9aaa (patch) | |
tree | 58499f2a67803b30a04c5d6b1506d226869d3180 /sqitch/deploy/change_nars_size_to_bigint.sql | |
parent | 3f3801d0dde9ffe83eec2789dbaf8c4be40a9280 (diff) | |
download | data-service-3457d5f6a648ba62b581be4d80be95e60f3c9aaa.tar data-service-3457d5f6a648ba62b581be4d80be95e60f3c9aaa.tar.gz |
WIP change nars size to bigint
Diffstat (limited to 'sqitch/deploy/change_nars_size_to_bigint.sql')
-rw-r--r-- | sqitch/deploy/change_nars_size_to_bigint.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/deploy/change_nars_size_to_bigint.sql b/sqitch/deploy/change_nars_size_to_bigint.sql new file mode 100644 index 0000000..cc94352 --- /dev/null +++ b/sqitch/deploy/change_nars_size_to_bigint.sql @@ -0,0 +1,7 @@ +-- Deploy guix-data-service:change_nars_size_to_bigint to pg + +BEGIN; + +ALTER TABLE nars ALTER COLUMN size TYPE bigint USING size::bigint; + +COMMIT; |