[Pgpool-general] PGPool II and Schemas

Yoshiyuki Asaba y-asaba at sraoss.co.jp
Thu Sep 6 01:44:36 UTC 2007


Hi,

From: David Jantzen <david.jantzen at comcast.net>
Subject: [Pgpool-general] PGPool II and Schemas
Date: Wed, 05 Sep 2007 17:32:26 -0700

> I'm new to PGPool, and hoping to use it for database replication in
> Amazon's EC2.  I came across this possible dealbreaker for me in the 2.0
> alpha documentation though:
> 
> "Objects in a schema other than public must be fully referenced like:
> 
> schema.object
> pgpool-II cannot resolve the correct schema when the path was set as
> follows: 
> set search_path = xxx
> and the schema name was omitted in a query."

It is only for parallel query. I've fixed the document.
Thanks.

--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp


More information about the Pgpool-general mailing list