Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit ee2b37a

Browse filesBrowse files
committed
Add some missing schema qualifications
This does not improve the security and reliability of the touched areas, but it makes the style more consistent. Author: Michael Paquier Reviewed-by- Noah Misch Discussion: https://postgr.es/m/20180309075538.GD9376@paquier.xyz
1 parent d3c09b9 commit ee2b37a
Copy full SHA for ee2b37a

File tree

Expand file treeCollapse file tree

3 files changed

+3
-3
lines changed
Filter options
Expand file treeCollapse file tree

3 files changed

+3
-3
lines changed

‎src/backend/catalog/information_schema.sql

Copy file name to clipboardExpand all lines: src/backend/catalog/information_schema.sql
+1-1Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -186,7 +186,7 @@ CREATE FUNCTION _pg_interval_type(typid oid, mod int4) RETURNS text
186186
AS
187187
$$SELECT
188188
CASE WHEN $1 IN (1186) /* interval */
189-
THEN upper(substring(format_type($1, $2) from 'interval[()0-9]* #"%#"' for '#'))
189+
THEN pg_catalog.upper(substring(pg_catalog.format_type($1, $2) from 'interval[()0-9]* #"%#"' for '#'))
190190
ELSE null
191191
END$$;
192192

‎src/bin/psql/command.c

Copy file name to clipboardExpand all lines: src/bin/psql/command.c
+1-1Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4578,7 +4578,7 @@ get_create_object_cmd(EditableObjectType obj_type, Oid oid,
45784578
printfPQExpBuffer(query,
45794579
"SELECT nspname, relname, relkind, "
45804580
"pg_catalog.pg_get_viewdef(c.oid, true), "
4581-
"array_remove(array_remove(c.reloptions,'check_option=local'),'check_option=cascaded') AS reloptions, "
4581+
"pg_catalog.array_remove(pg_catalog.array_remove(c.reloptions,'check_option=local'),'check_option=cascaded') AS reloptions, "
45824582
"CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text "
45834583
"WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption "
45844584
"FROM pg_catalog.pg_class c "

‎src/test/isolation/isolationtester.c

Copy file name to clipboardExpand all lines: src/test/isolation/isolationtester.c
+1-1Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -201,7 +201,7 @@ main(int argc, char **argv)
201201
PQclear(res);
202202

203203
/* Get the backend pid for lock wait checking. */
204-
res = PQexec(conns[i], "SELECT pg_backend_pid()");
204+
res = PQexec(conns[i], "SELECT pg_catalog.pg_backend_pid()");
205205
if (PQresultStatus(res) == PGRES_TUPLES_OK)
206206
{
207207
if (PQntuples(res) == 1 && PQnfields(res) == 1)

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.