From: | Tomas Vondra <tomas(dot)vondra(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: psql \dX: check schema when listing statistics objects |
Date: | 2021-07-26 15:42:26 |
Message-ID: | E1m82kM-0003IP-Je@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
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
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/f68b609230689f9886a46e5d9ab8d6cdd947e0dc
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(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2021-07-26 15:42:41 | pgsql: psql \dX: check schema when listing statistics objects |
Previous Message | Dean Rasheed | 2021-07-26 13:17:33 | pgsql: Allow numeric scale to be negative or greater than precision. |