Hi, On 2016/10/05 16:57, Rajkumar Raghuwanshi wrote: > I observed, when creating foreign table with range partition, data is not > inserting into specified partition range. below are steps to reproduce. > > [ ... ] > > postgres=# INSERT INTO test_range (a) values (5),(25),(15); > INSERT 0 3 > > postgres=# select tableoid::regclass, * from test_range; > tableoid | a > ------------------+---- > ft_test_range_p1 | 5 > ft_test_range_p2 | 15 > ft_test_range_p3 | 25 > (3 rows) > > --Here ft_test_range_p2 is created for range 20-30 having value 15.
Thanks a lot for testing. That's a bug. I found that it is caused by the FDW plans getting paired with the wrong result relations during ExecInitModifyTable() initialization. I will include a fix for the same in the patch set that I will be sending soon in reply to Robert's review comments on patch 0002 . Thanks, Amit  https://www.postgresql.org/message-id/CA%2BTgmoY1aQ5iPz0S2GBJw4YUR1Z2Qg5iKUf8YJSo2Ctya4ZmNg%40mail.gmail.com -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers