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

Commit5849b6e

Browse files
committed
Fix incorrect pattern-match processing in psql's \det command.
listForeignTables' invocation of processSQLNamePattern did not match upwith the other ones that handle potentially-schema-qualified names; itfailed to make use of pg_table_is_visible() and also passed the namearguments in the wrong order. Bug seems to have been aboriginal in commit0d692a0. It accidentally sort of worked as long as you didn'tinquire too closely into the behavior, although the silliness was laterexposed by inconsistencies in the test queries added by59efda3(which I probably should have questioned at the time, but didn't).Per bug #13899 from Reece Hart. Patch by Reece Hart and Tom Lane.Back-patch to all affected branches.
1 parent280d05c commit5849b6e

File tree

1 file changed

+2
-1
lines changed

1 file changed

+2
-1
lines changed

‎src/bin/psql/describe.c

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4243,7 +4243,8 @@ listForeignTables(const char *pattern, bool verbose)
42434243
"d.objoid = c.oid AND d.objsubid = 0\n");
42444244

42454245
processSQLNamePattern(pset.db,&buf,pattern, false, false,
4246-
NULL,"n.nspname","c.relname",NULL);
4246+
"n.nspname","c.relname",NULL,
4247+
"pg_catalog.pg_table_is_visible(c.oid)");
42474248

42484249
appendPQExpBufferStr(&buf,"ORDER BY 1, 2;");
42494250

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp