[DOCS] Row movement in Subpartition in postgres
От | Shashi Singh |
---|---|
Тема | [DOCS] Row movement in Subpartition in postgres |
Дата | |
Msg-id | 7C6B0447A089EA45B5ABB399D50EB21E01BC36C1AE@COMV-MBX01-GGN.COMVIVA.COM обсуждение исходный текст |
Список | pgsql-docs |
Dear Team,
Kindly help me on the below query, If it is possible in Postgresql?
How to do the row movement in case of update on subpartition key in postgres . Consider T is master table with seq_id as Partition key. t1 and t2 are the partion table. I have done the range subpartitiong on t1 and t2 with month as subpartition key.
T -> t1->t1_may
t1->t1_june
T -> t2->t2_may
t2->t2_june
Now how will I move the row from t2_june to t1_june in case I update the row in sub partition?
Thanks & Regards,
Shashi Singh
В списке pgsql-docs по дате отправления: