Re: list of extended statistics on psql (\dX)

2021-07-26 Thread Tatsuro Yamada
Hi Tomas and Justin, On 2021/07/27 4:26, Tomas Vondra wrote: Hi, I've pushed the last version of the fix, including the regression tests etc. Backpatch to 14, where \dX was introduced. Thank you! Regards, Tatsuro Yamada

Re: list of extended statistics on psql (\dX)

2021-07-26 Thread Tomas Vondra
Hi, I've pushed the last version of the fix, including the regression tests etc. Backpatch to 14, where \dX was introduced. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: list of extended statistics on psql (\dX)

2021-07-07 Thread Tatsuro Yamada
Hi Tomas and Justin, On 2021/06/07 4:47, Tomas Vondra wrote: Here's a slightly more complete patch, tweaking the regression tests a bit to detect this. I tested your patch on PG14beta2 and PG15devel. And they work fine. === All 209 tests passed. === N

Re: list of extended statistics on psql (\dX)

2021-06-06 Thread Tomas Vondra
Hi, Here's a slightly more complete patch, tweaking the regression tests a bit to detect this. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index 2abf255798..eba659705e 100644

Re: list of extended statistics on psql (\dX)

2021-05-30 Thread Tomas Vondra
On 5/30/21 7:24 PM, Justin Pryzby wrote: > On Wed, Jan 20, 2021 at 11:00:50PM +0100, Tomas Vondra wrote: >> Thanks, I've pushed this. I had to tweak the regression tests a bit, for two >> reasons: > > \dX isn't checking schema visibility rules, so accidentally shows stats > objects > outside o

Re: list of extended statistics on psql (\dX)

2021-05-30 Thread Justin Pryzby
On Wed, Jan 20, 2021 at 11:00:50PM +0100, Tomas Vondra wrote: > Thanks, I've pushed this. I had to tweak the regression tests a bit, for two > reasons: \dX isn't checking schema visibility rules, so accidentally shows stats objects outside of the search path. I noticed after installing the PG14b1