Hey,
Suppose I have a table with the following fields:
CREATE TABLE distributors (
id DECIMAL(3) PRIMARY KEY,
name VARCHAR(40),
status INTEGER
);
I would ike to partition this table based on status which can be [0,1,2,3,4].
I was wondering if the records can change their status. i.e. If I did
UPDATE distributors SET status = 4 WHERE id = 231122;
would POSTGRESQL automatically change the record from the current
partition (say partition where status = 3) to the partition where
status = 4?
Or would I have to explicitly delete it from one partition table, and
reinsert it in the other?
Thanks,
Ram