change_data_type_of_shard_key_1.sql

BEGIN;
SET search_path TO 'public';
CREATE SCHEMA temp_schema;
CREATE TABLE temp_schema.deviceid_rollup_daily (LIKE deviceid_rollup_daily INCLUDING ALL);
ALTER TABLE temp_schema.deviceid_rollup_daily ALTER COLUMN state SET DATA TYPE character varying(100);
SELECT create_distributed_table('temp_schema.deviceid_rollup_daily','state');
INSERT INTO temp_schema.deviceid_rollup_daily SELECT * from deviceid_rollup_daily;
END;

-- Move the new table to the actual schema.
BEGIN;
SET search_path TO 'public';
DROP TABLE deviceid_rollup_daily;
SELECT run_command_on_shards('temp_schema.deviceid_rollup_daily','ALTER TABLE %s SET SCHEMA public');
SET citus.enable_ddl_propagation to off;
ALTER TABLE temp_schema.deviceid_rollup_daily SET SCHEMA public;
SET citus.enable_ddl_propagation to on;
DROP SCHEMA temp_schema;
END;