summaryrefslogtreecommitdiff
path: root/src/test/regress/input/create_function_2.source
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/input/create_function_2.source')
-rw-r--r--src/test/regress/input/create_function_2.source5
1 files changed, 3 insertions, 2 deletions
diff --git a/src/test/regress/input/create_function_2.source b/src/test/regress/input/create_function_2.source
index 4bcf24c601..07d26c1d8f 100644
--- a/src/test/regress/input/create_function_2.source
+++ b/src/test/regress/input/create_function_2.source
@@ -28,8 +28,9 @@ CREATE FUNCTION equipment(hobbies_r)
CREATE FUNCTION user_relns()
RETURNS setof name
AS 'select relname
- from pg_class
- where relname !~ ''pg_.*'' and
+ from pg_class c, pg_namespace n
+ where relnamespace = n.oid and
+ (nspname !~ ''pg_.*'' and nspname <> ''information_schema'') and
relkind <> ''i'' '
LANGUAGE 'sql';