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 [1].
Thanks,
Amit
[1]
https://www.postgresql.org/message-id/CA%2BTgmoY1aQ5iPz0S2GBJw4YUR1Z2Qg5iKUf8YJSo2Ctya4ZmNg%40mail.gmail.com