Partition key column change

[Santoshkumar00723]

Hi Keith,

Can we change Partition key column from (col1 to col2) ?

We can able to update in part_config table but how to make it reflect on main table.

[keithf4]

I don't believe this is possible to do in PostgreSQL itself, so it's not a limitation in pg_partman that it cannot be done. Looking at the ALTER TABLE statement here I'm not seeing anything to allow that

https://www.postgresql.org/docs/17/sql-altertable.html

You would have to create a new table and migrate that data to the new table.

[keithf4]

Moving this to a discussion