[ADMIN] Delete from base table and not partitions

Question: I have a base table with several temporal partitions like this: base_table partition_1 partition_2 There are check rules on partitions, and trigger rules on the base table to ensure data loaded into base_table goes to a correct partition. I added partition_3 and create

[ADMIN] Delete from base table and not partitions

Question: I have a base table with several temporal partitions like this: base_table partition_1 partition_2 There are check rules on partitions, and trigger rules on the base table to ensure data loaded into base_table goes to a correct partition. I added partition_3 and create

Re: [ADMIN] Delete from base table and not partitions

Thank you very much, I was not aware of the 'ONLY' clause. Nuwan. Tom Lane <[EMAIL PROTECTED]> wrote: Nuwan Liyanage writes: > Now I added the trigger rule to base_table and the data for > partition_3 is going to the right place, but I am stuck with some data > in the actual base_t

Re: [ADMIN] Delete from base table and not partitions

Nuwan Liyanage <[EMAIL PROTECTED]> writes: > Now I added the trigger rule to base_table and the data for > partition_3 is going to the right place, but I am stuck with some data > in the actual base_table. How could I move that data from the base > table to the partition_3? Somethi

[ADMIN] Delete from base table and not partitions

Question: I have a base table with several temporal partitions like this: base_table partition_1 partition_2 There are check rules on partitions, and trigger rules on the base table to ensure data loaded into base_table goes to a correct partition. I added part