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_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. regards, tom lane --------------------------------- Looking for last minute shopping deals? Find them fast with Yahoo! Search.