changing_var_char_to_text_part_col.sql

CREATE TABLE test (x varchar, y int);
SELECT create_distributed_table('test', 'x');
BEGIN;
SET LOCAL citus.enable_ddl_propagation TO off;
DELETE FROM pg_depend WHERE objid = 'test'::regclass AND objid = refobjid RETURNING *;
ALTER TABLE test ALTER COLUMN x TYPE text;
SELECT * FROM run_command_on_placements('test', 'ALTER TABLE %I ALTER COLUMN x TYPE text');
UPDATE pg_dist_partition SET partkey = column_name_to_column('test', 'x') WHERE logicalrelid = 'test'::regclass;
COMMIT;