Re: Declarative partitioning - another take

<div dir="ltr"><br /><div class="gmail_extra">On Tue, Oct 4, 2016 at 1:32 PM, Amit Langote <span dir="ltr"><<a
href="mailto:Langote_Amit_f8@lab.ntt.co.jp"target="_blank">Langote_Amit_f8@lab.ntt.co.jp</a><wbr />></span>
wrote:<span><br/><br /></span><span></span><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px
0px0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><span> </span>Attached updated patches.<br /><br
/>Thanks,<br /> Amit<br /></blockquote></div><br />Hi,<br /><br />I observed, when creating foreign table with range
partition,data is not inserting into specified partition range. below are steps to reproduce.<br /><br />CREATE
EXTENSIONpostgres_fdw;<br />CREATE SERVER pwj_server FOREIGN DATA WRAPPER postgres_fdw OPTIONS (dbname 'postgres', port
'5432',use_remote_estimate'true');<br />CREATE USER MAPPING FOR PUBLIC SERVER pwj_server;<br /><br />CREATE TABLE
test_range(a int) PARTITION BY RANGE(a);<br /><br />CREATE TABLE test_range_p1 (a int);<br />CREATE FOREIGN TABLE
ft_test_range_p1PARTITION OF test_range FOR VALUES START (1) END (10) SERVER pwj_server OPTIONS (TABLE_NAME
'test_range_p1');<br/><br />CREATE TABLE test_range_p2 (a int);<br />CREATE FOREIGN TABLE ft_test_range_p2 PARTITION OF
test_rangeFOR VALUES START (20) END (30) SERVER pwj_server OPTIONS (TABLE_NAME 'test_range_p2');<br /><br />CREATE
TABLEtest_range_p3 (a int);<br />CREATE FOREIGN TABLE ft_test_range_p3 PARTITION OF test_range FOR VALUES START (10)
END(20) SERVER pwj_server OPTIONS (TABLE_NAME 'test_range_p3');<br /><br />postgres=# INSERT INTO test_range (a) values
(5),(25),(15);<br/>INSERT 0 3<br /><br />postgres=# select tableoid::regclass, * from test_range;<br />    
tableoid    | a  <br />------------------+----<br /> ft_test_range_p1 |  5<br /> ft_test_range_p2 | 15<br
/> ft_test_range_p3| 25<br />(3 rows)<br /><br /></div><div class="gmail_extra">--Here ft_test_range_p2 is created for
range20-30 having value 15.<br /></div><div class="gmail_extra"><br />Thanks & Regards,<br />Rajkumar
Raghuwanshi<br/>QMG, EnterpriseDB Corporation<br /><br /></div></div>