| From: | "Ram Ravichandran" <ramkaka(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org(dot) |
| Subject: | Postgresql partitioning |
| Date: | 2008-03-22 00:15:56 |
| Message-ID: | c8cd6fbb0803211715q59cf6239v2dc36e6fe070edb0@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Jones | 2008-03-22 00:59:55 | Re: Postgresql partitioning |
| Previous Message | Markus Wollny | 2008-03-21 22:34:21 | Re: Transaction wraparound problem with database postgres |