pgpool2.git / summary / log / commit / refs

commit    91dcb630ec0aa79440fb5eedc104f87921f852dc
Author:   Tatsuo Ishii <ishii@postgresql.org>
Date:     Fri Jul 11 00:54:59 2014 +0000

    Fix SELECT statement used in pool_table_name_to_oid() for to_regclass.
    
    By previous commit it always retruns 0.


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

diff --git a/src/utils/pool_select_walker.c b/src/utils/pool_select_walker.c
index c2cd465e8..4afad936d 100644
--- a/src/utils/pool_select_walker.c
+++ b/src/utils/pool_select_walker.c
@@ -948,7 +948,7 @@ int pool_table_name_to_oid(char *table_name)
  */
 #define TABLE_TO_OID_QUERY "SELECT pgpool_regclass('%s')"
 #define TABLE_TO_OID_QUERY2 "SELECT oid FROM pg_class WHERE relname = '%s'"
-#define TABLE_TO_OID_QUERY3 "SELECT COALESCE(0, to_regclass('%s'))"
+#define TABLE_TO_OID_QUERY3 "SELECT COALESCE(to_regclass('%s')::oid, 0)"
 
 	int oid = 0;
 	static POOL_RELCACHE *relcache;


[parent: 7bfedf9e18bd]