[pgpool-general: 3025] Pgpool Partion rules with geometry columns

[Thao Nguyen Duy]

Hi all,
Could you help me on this error.
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
* province_code: integer
* eco_zone_code :integer
* name: character
* geom:pgpool-general at pgpool.net.
The definition of partition is :
> CREATE OR REPLACE FUNCTION pgpool_catalog.dis_def_province(anyelement)
>   RETURNS integer AS
> $BODY$
>     SELECT CASE WHEN $1 > 0 AND $1 <= 35 THEN 0
>         
>         ELSE 1
>     END;
> $BODY$
>   LANGUAGE sql VOLATILE
>   COST 100;
> ALTER FUNCTION pgpool_catalog.dis_def_province(anyelement)
>   OWNER TO postgres;
As I expected all provinces have province_code > 35 will be stored on the
node1.
But the rule does not affected.
Thank you so much!


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140714/eff2966e/attachment-0001.html>