PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.
When a partition key is updated on a row, the row is moved to the appropriate partition.