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

Commit471d558

Browse files
committed
Adjust psql \d query to avoid use of @> operator.
It seems that the parray_gin extension has seen fit to introduce a"text[] @> text[]" operator, which conflicts with the core"anyarray @> anyarray" operator, causing ambiguous-operator failuresif the input arguments are coercible to text[] without being exactlythat type. This strikes me as a bad idea, but it's out there andpeople use it. As of v10, that breaks psql's query that tries totest "pg_statistic_ext.stxkind @> '{d}'", since stxkind is char[].The best workaround seems to be to avoid use of that operator.We can use a scalar-vs-array test "'d' = any(stxkind)" instead;that's arguably more readable anyway.Per report from Justin Pryzby. Backpatch to v10 where thisquery was added.Discussion:https://postgr.es/m/20171022181525.GA21884@telsasoft.com
1 parent7c98159 commit471d558

File tree

1 file changed

+2
-2
lines changed

1 file changed

+2
-2
lines changed

‎src/bin/psql/describe.c

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2423,8 +2423,8 @@ describeOneTableDetails(const char *schemaname,
24232423
" FROM pg_catalog.unnest(stxkeys) s(attnum)\n"
24242424
" JOIN pg_catalog.pg_attribute a ON (stxrelid = a.attrelid AND\n"
24252425
" a.attnum = s.attnum AND NOT attisdropped)) AS columns,\n"
2426-
"(stxkind @> '{d}') AS ndist_enabled,\n"
2427-
"(stxkind @> '{f}') AS deps_enabled\n"
2426+
"'d' = any(stxkind) AS ndist_enabled,\n"
2427+
"'f' = any(stxkind) AS deps_enabled\n"
24282428
"FROM pg_catalog.pg_statistic_ext stat "
24292429
"WHERE stxrelid = '%s'\n"
24302430
"ORDER BY 1;",

0 commit comments

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