pgpool2.git / summary / log / commit / refs

commit    5e65429cd325ef2cbec22d114939cf07b3bcfa2e
Author:   Tatsuo Ishii <ishii@postgresql.org>
Date:     Tue Jun 25 05:50:31 2013 +0000

    Register pgpool_regclass in pg_catalog schema.  This is necessary to
    deal with clients which restricts schema search path to pg_catalog
    only. Postgres_fdw is such a client.


 sql/pgpool-regclass/pgpool-regclass.sql.in   | 2 +-
 sql/pgpool-regclass/pgpool_regclass--1.0.sql | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/sql/pgpool-regclass/pgpool-regclass.sql.in b/sql/pgpool-regclass/pgpool-regclass.sql.in
index b7b2be2cb..df3080923 100644
--- a/sql/pgpool-regclass/pgpool-regclass.sql.in
+++ b/sql/pgpool-regclass/pgpool-regclass.sql.in
@@ -1,4 +1,4 @@
-CREATE OR REPLACE FUNCTION pgpool_regclass(cstring)
+CREATE OR REPLACE FUNCTION pg_catalog.pgpool_regclass(cstring)
 RETURNS oid
 AS 'MODULE_PATHNAME', 'pgpool_regclass'
 LANGUAGE C STRICT;
diff --git a/sql/pgpool-regclass/pgpool_regclass--1.0.sql b/sql/pgpool-regclass/pgpool_regclass--1.0.sql
index df773dc92..5cb50a391 100644
--- a/sql/pgpool-regclass/pgpool_regclass--1.0.sql
+++ b/sql/pgpool-regclass/pgpool_regclass--1.0.sql
@@ -1,7 +1,7 @@
 -- complain if script is sourced in psql, rather than via CREATE EXTENSION
 \echo Use "CREATE EXTENSION pgpool_regclass" to load this file. \quit
 
-CREATE FUNCTION pgpool_regclass(IN expression cstring)
+CREATE FUNCTION pg_catalog.pgpool_regclass(IN expression cstring)
 RETURNS oid
 AS 'MODULE_PATHNAME', 'pgpool_regclass'
 LANGUAGE C STRICT;


[parent: caffc713cae1]