Hi all,
We’re having a bit of a problem getting a partitioned table altered. The parent table has two partitions, which we have
detachedfrom it. The parent, however, refuses to be altered, as the parent still shows it is partitioned by its list
attribute,I.e. from \d+
Partition key: LIST(batched)
Is there any way to remove the partition key, or do we simply need to create a new table with the structure we need,
dropthe old one, then rename the new one to that original name and reattach the partitions?
The docs on this seem a bit unclear on this issue.
—
Jay
Sent from my iPad