<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;"><div>Hi all,</div><div>Could you help me on this error. </div><div>I have setup pgpool-II with 3 servers (192.168.1.131: database node0, 192.168.1.132: pgpool, 192.168.1.133:database node 1) with parallel mode. In the partition rules I defined rule to partition a table into (province table) 2 database node (node0 and node1). The structure of province is </div><ul><li>province_code: integer</li><li>eco_<span style="font-style: italic;">zone_</span>code :integer</li><li>name: character</li><li>geom:pgpool-general@pgpool.net.</li></ul><div>The definition of partition is : </div><blockquote style="margin:0 0 0 40px; border:none; padding:0px;"><div><div>CREATE OR REPLACE FUNCTION pgpool_catalog.dis_def_province(anyelement)</div><div> RETURNS integer AS</div><div>$BODY$</div><div> SELECT CASE WHEN $1 > 0 AND $1 <= 35 THEN 0</div><div> </div><div> ELSE 1</div><div> END;</div><div>$BODY$</div><div> LANGUAGE sql VOLATILE</div><div> COST 100;</div><div>ALTER FUNCTION pgpool_catalog.dis_def_province(anyelement)</div><div> OWNER TO postgres;</div></div></blockquote><div>As I expected all provinces have province_code > 35 will be stored on the node1.</div><div>But the rule does not affected.</div><div>Thank you so much!</div></body></html>