[Pgpool-general] Fwd: PGPOOL II 2.3.3 hang in ssl mode

[AI Rumman]

Addition to the above, I found that,

When I use the following query it works :

SELECT d.datname as "Name",
       r.rolname as "Owner",
       d.encoding as "Encoding"
FROM pg_catalog.pg_database d
  JOIN pg_catalog.pg_roles r ON d.datdba = r.oid
ORDER BY 1

But the following query does not work:

SELECT d.datname as "Name",
       r.rolname as "Owner",
       pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding"
FROM pg_catalog.pg_database d
  JOIN pg_catalog.pg_roles r ON d.datdba = r.oid
ORDER BY 1

The function call "pg_catalog.pg_encoding_to_char(d.encoding)" somehow makes
the Pgpool hang in SSL mode.

---------- Forwarded message ----------
From: AI Rumman <rummandba at gmail.com>
Date: Sun, May 9, 2010 at 12:06 PM
Subject: PGPOOL II 2.3.3 hang in ssl mode
To: pgpool-general at pgfoundry.org


I am using Pgpool II 2.3.3 with Postgresql 8.3.8.

When I use command \l at postgresql client the query is working perfectly.

But if I used the command from pgpool II client which is connected with
postgresql in ssl mode, it gets hang.

Again if I use the command from pgpool II client in non-ssl mode, it works
fine.

Any help please.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20100509/86327cc8/attachment.html>