Thank you very much, I was not aware of the 'ONLY' clause. Nuwan.
Tom Lane <tgl@sss.pgh.pa.us> 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_table. How could I move that data from the base > table to the partition_3?
Something involving SELECT ... FROM ONLY base_table and then DELETE FROM ONLY base_table would do it for you.
