Postgresql partitioning

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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