Re: list of extended statistics on psql - Mailing list pgsql-hackers

From Tatsuro Yamada
Subject Re: list of extended statistics on psql
Date
Msg-id d4fe2cf0-9aa9-8182-25d1-230dd6b98138@nttcom.co.jp_1
Whole thread Raw
In response to Re: list of extended statistics on psql  (Julien Rouhaud <rjuju123@gmail.com>)
Responses Re: list of extended statistics on psql  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Hi Julien!
  

> Thanks also for the documentation and regression tests.  This overall looks
> good, I just have a two comments:


Thank you for reviewing the patch! :-D


> - there's a whitespace issue in the documentation part:
> 
> add_list_extended_stats_for_psql_by_dX_command.patch:10: tab in indent.
>       <varlistentry>
> warning: 1 line adds whitespace errors.


Oops, I forgot to use "git diff --check". I fixed it.

  
> - You're sorting the output on schema, table, extended statistics and columns
>    but I think the last one isn't required since extended statistics names are
>    unique.


You are right.
The sort key "columns" was not necessary so I removed it.

Attached new patch includes the above two fixes:

   - Fix whitespace issue in the documentation part
   - Remove unnecessary sort key from the query
      (ORDER BY 1, 2, 3, 4 -> ORDER BY 1, 2, 3)


Thanks,
Tatsuro Yamada


Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Autovac cancellation is broken in v14
Next
From: Peter Geoghegan
Date:
Subject: Re: XMAX_LOCK_ONLY and XMAX_COMMITTED (fk/multixact code)