Thread: pgsql: psql \dX: check schema when listing statistics objects
psql \dX: check schema when listing statistics objects Commit ad600bba04 added psql command \dX listing extended statistics objects, but it failed to consider search_path when selecting the elements so some of the returned elements might be invisible. The visibility was already considered for tab completion (added by commit d99d58cdc8), so adding it to the query is fairly simple. Reported and fix by Justin Pryzby, regression tests by me. Backpatch to PostgreSQL 14, where \dX was introduced. Batchpatch-through: 14 Author: Justin Pryzby Reviewed-by: Tatsuro Yamada Discussion: https://postgr.es/m/c027a541-5856-75a5-0868-341301e1624b%40nttcom.co.jp_1 Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/611e42444b121370f561d860552beb7d28dacbf8 Modified Files -------------- src/bin/psql/describe.c | 2 +- src/test/regress/expected/stats_ext.out | 52 +++++++++++++++++++++------------ src/test/regress/sql/stats_ext.sql | 5 ++++ 3 files changed, 40 insertions(+), 19 deletions(-)