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
This e-mail and all material transmitted with it are for the use of the intended recipient(s) ONLY and contains confidential and/or privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies and the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken pursuant to the contents of the present e-mail is strictly prohibited and is unlawful. The recipient acknowledges that Comviva Technologies Limited or its management or directors, are unable to exercise control or ensure the integrity over /of the contents of the information contained in e-mail. Any views expressed herein are those of the individual sender only and no binding nature of the contents shall be implied or assumed unless the sender does so expressly with due authority of Comviva Technologies Limited. E-mail and any contents transmitted with it are prone to viruses and related defects despite all efforts to avoid such by Comviva Technologies Limited.