Postgresql partitioning

["Ram Ravichandran" <ramkaka@xxxxxxxxx>]

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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general