[Pgpool-general] dblink complains about what?!

Alessandro Candini candini at meeo.it
Mon Feb 7 11:11:33 UTC 2011


postgres at desktop:~$ /usr/lib/postgresql/9.0.1/bin/psql -p 9999 -d mydb -h
localhost -U myuser -c "SELECT COUNT(*) FROM mytable;"
ERROR:  pgpool2 sql restriction(notice from dblink)
DETAIL:   SELECT sum(pool_g$0) AS count FROM dblink('host=localhost dbname=mydb
port=9999 user=myuser','SELECT pool_parallel("SELECT count(*) FROM
mytable")',false) AS pool_t$0g (pool_g$0 bigint )

...and the error message ends like this.

What does this mean...where can I look at to find the error. Both pgpool and
myuser are SUPERUSER and I perform the parallel query from my machine to other
two remote machines (with pg_hba properly configured).

I really can't understand what's wrong...



More information about the Pgpool-general mailing list