On Fri, 10 Jan 2025 20:37:17 +0800
Julien Rouhaud <rjuju...@gmail.com> wrote:

> Hi,
> 
> On Fri, Jan 10, 2025 at 01:04:14PM +0100, Magnus Hagander wrote:
> > In an effort to make at least a couple of more people realize they have to
> > run ALTER EXTENSION UPDATE after they've upgraded an extension,  as well as
> > make it a bit easier to realize when you have to do it, I propose we add
> > the default version of an extension to \dx in psql.
> 
> +1, I need the info very often and \dx is way faster than writing a query for
> that when I need it, especially since \dx output is not too big.
> 
> > We currently show the
> > installed version in the schema, but no indications that a newer one might
> > be installed on the system.
> > 
> > PFA a patch to do this.
> 
> Patch LGTM, tested locally and I like the output.

I have a minor comment.

+                                         "LEFT JOIN 
pg_catalog.pg_available_extensions() ae(name, default_version, comment)  ON 
ae.name=e.extname "

For consistency with around codes, it seems better to add a space before and 
after "=",
like "ae.name = e.extname".

Regards,
Yugo Nagata

-- 
Yugo Nagata <nag...@sraoss.co.jp>


Reply via email to