Movatterモバイル変換

[0]ホーム
URL:

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

 Sign up
Appearance settings

Commitee2b37a

Browse 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 PaquierReviewed-by- Noah MischDiscussion:https://postgr.es/m/20180309075538.GD9376@paquier.xyz
1 parentd3c09b9 commitee2b37a

File tree

3 files changed

+3
-3
lines changed

3 files changed

+3
-3
lines changed

‎src/backend/catalog/information_schema.sql

Lines 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 $1IN (1186)/* interval*/
189-
THENupper(substring(format_type($1, $2)from'interval[()0-9]* #"%#"' for'#'))
189+
THENpg_catalog.upper(substring(pg_catalog.format_type($1, $2)from'interval[()0-9]* #"%#"' for'#'))
190190
ELSEnull
191191
END$$;
192192

‎src/bin/psql/command.c

Lines 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

Lines 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],"SELECTpg_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)
[8]ページ先頭
©2009-2025 Movatter.jp