[Pgpool-general] PGPool II and Schemas

David Jantzen david.jantzen at comcast.net
Thu Sep 6 00:32:26 UTC 2007


Hi All,

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."

My limited testing indicates that this is no longer the case, but I'd
appreciate verification from more experienced users.

Thanks,
David



More information about the Pgpool-general mailing list