Postgresql partitioning

Поиск
Список
Период
Сортировка
От Ram Ravichandran
Тема Postgresql partitioning
Дата
Msg-id c8cd6fbb0803211715q59cf6239v2dc36e6fe070edb0@mail.gmail.com
обсуждение исходный текст
Ответы Re: Postgresql partitioning
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Markus Wollny"
Дата:
Сообщение: Re: Transaction wraparound problem with database postgres
Следующее
От: Erik Jones
Дата:
Сообщение: Re: Postgresql partitioning