Re: Adding extension default version to \dx

2025-03-24 Thread Magnus Hagander
On Sat, Mar 22, 2025 at 11:40 AM Jelte Fennema-Nio wrote: > On Tue, 25 Feb 2025 at 17:11, Nathan Bossart > wrote: > > > > On Tue, Feb 25, 2025 at 04:42:37PM +0100, Magnus Hagander wrote: > > > Thanks goes to both you and the previous responders - I did manage to > mute > > > this thread away an

Re: Adding extension default version to \dx

2025-03-22 Thread Jelte Fennema-Nio
On Tue, 25 Feb 2025 at 17:11, Nathan Bossart wrote: > > On Tue, Feb 25, 2025 at 04:42:37PM +0100, Magnus Hagander wrote: > > Thanks goes to both you and the previous responders - I did manage to mute > > this thread away and missed the early replies, but got Jeltes the other day > > which brought

Re: Adding extension default version to \dx

2025-02-25 Thread Nathan Bossart
On Tue, Feb 25, 2025 at 04:42:37PM +0100, Magnus Hagander wrote: > Thanks goes to both you and the previous responders - I did manage to mute > this thread away and missed the early replies, but got Jeltes the other day > which brought it back up on my list to get to within the Not Too Long > Futu

Re: Adding extension default version to \dx

2025-02-25 Thread Magnus Hagander
On Tue, Feb 25, 2025 at 4:40 PM Nathan Bossart wrote: > On Sun, Feb 23, 2025 at 04:05:34PM +0100, Jelte Fennema-Nio wrote: > > On Sun Feb 23, 2025 at 3:51 PM CET, Jelte Fennema-Nio wrote: > >> Attached is an updated patch that fixes the tests and changes the > >> whitespace as discussed (includin

Re: Adding extension default version to \dx

2025-02-25 Thread Nathan Bossart
On Sun, Feb 23, 2025 at 04:05:34PM +0100, Jelte Fennema-Nio wrote: > On Sun Feb 23, 2025 at 3:51 PM CET, Jelte Fennema-Nio wrote: >> Attached is an updated patch that fixes the tests and changes the >> whitespace as discussed (including removing a spurious second space >> before the ON, which I not

Re: Adding extension default version to \dx

2025-02-23 Thread Jelte Fennema-Nio
On Sun Feb 23, 2025 at 3:51 PM CET, Jelte Fennema-Nio wrote: Attached is an updated patch that fixes the tests and changes the whitespace as discussed (including removing a spurious second space before the ON, which I noticed while changing it). As well as a seprate patch that changes the "c" ali

Re: Adding extension default version to \dx

2025-02-23 Thread Jelte Fennema-Nio
On Mon Jan 27, 2025 at 8:39 PM CET, Nathan Bossart wrote: +1 Separately, I see that there's one update needed for src/test/regress/expected/psql.out. The documentation for \dx looks generic enough that it probably doesn't need any updates, though. Attached is an updated patch that fixes the t

Re: Adding extension default version to \dx

2025-01-27 Thread Nathan Bossart
On Wed, Jan 15, 2025 at 02:11:05AM +0900, Yugo Nagata wrote: > 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 bette

Re: Adding extension default version to \dx

2025-01-27 Thread Nathan Bossart
On Fri, Jan 10, 2025 at 03:56:31PM +0100, Michael Banck wrote: > 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

Re: Adding extension default version to \dx

2025-01-14 Thread Yugo Nagata
On Fri, 10 Jan 2025 20:37:17 +0800 Julien Rouhaud 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 > > m

Re: Adding extension default version to \dx

2025-01-10 Thread Michael Banck
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

Re: Adding extension default version to \dx

2025-01-10 Thread Julien Rouhaud
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

Adding extension default version to \dx

2025-01-10 Thread Magnus Hagander
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. We currently show the i