pgpool2.git / summary / log / commit / refs

commit    caea5dc3c148e70d4be210e7c66c8c36c8b85a43
Author:   Tatsuo Ishii <ishii@postgresql.org>
Date:     Tue May 14 22:46:44 2013 +0000

    Fix error when pgpool_regclass is not installed.
    
    The query used in pool_has_pgpool_regclass() fails if pgpool_regclass
    does not exist. The bug was introduced in 3.2.4.  See [pgpool-general:
    1722] for more details.


 pool_select_walker.c | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/pool_select_walker.c b/pool_select_walker.c
index b9f86eaa6..58eab6c49 100644
--- a/pool_select_walker.c
+++ b/pool_select_walker.c
@@ -739,7 +739,7 @@ bool pool_has_pgpool_regclass(void)
 /*
  * Query to know if pgpool_regclass exists.
  */
-#define HASPGPOOL_REGCLASSQUERY "SELECT count(*) FROM pg_catalog.pg_proc AS p WHERE p.proname = 'pgpool_regclass' AND has_function_privilege('%s', 'pgpool_regclass(cstring)', 'execute')"
+#define HASPGPOOL_REGCLASSQUERY "SELECT count(*) from (SELECT has_function_privilege('%s', 'pgpool_regclass(cstring)', 'execute') WHERE EXISTS(SELECT * FROM pg_catalog.pg_proc AS p WHERE p.proname = 'pgpool_regclass')) AS s"
 
 	bool result;
 	static POOL_RELCACHE *relcache;


[parent: 4ebdca7d00f4]