postgres.git / summary / log / commit / refs

commit    112e40b867b3351ecc49b86a4fa07ec182b82e65
Author:   Magnus Hagander <magnus@hagander.net>
Date:     Thu Jun 05 07:54:16 2025 +0000
First released in: 18.0

    psql: fix order of join clauses when listing extensions
    
    Commit d696406a9b2 added a new join to the query for extensions, but did
    so in the wrong place, causing the AND clause to be applied to the wrong
    join.
    
    Author: Suraj Kharage <suraj.kharage@enterprisedb.com>
    Reviewed-By: Dilip Kumar <dilipbalaut@gmail.com>
    Discussion: https://postgr.es/m/CAF1DzPVBrN-cmPB2zb7ZU=2J4vEF2fNdArGCG9w+9fnKq4v8tg@mail.gmail.com


 src/bin/psql/describe.c | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c
index 1d08268393e..24e0100c9f0 100644
--- a/src/bin/psql/describe.c
+++ b/src/bin/psql/describe.c
@@ -6188,8 +6188,8 @@ listExtensions(const char *pattern)
 					  "FROM pg_catalog.pg_extension e "
 					  "LEFT JOIN pg_catalog.pg_namespace n ON n.oid = e.extnamespace "
 					  "LEFT JOIN pg_catalog.pg_description d ON d.objoid = e.oid "
-					  "LEFT JOIN pg_catalog.pg_available_extensions() ae(name, default_version, comment) ON ae.name = e.extname "
-					  "AND d.classoid = 'pg_catalog.pg_extension'::pg_catalog.regclass\n",
+					  "AND d.classoid = 'pg_catalog.pg_extension'::pg_catalog.regclass "
+					  "LEFT JOIN pg_catalog.pg_available_extensions() ae(name, default_version, comment) ON ae.name = e.extname\n",
 					  gettext_noop("Name"),
 					  gettext_noop("Version"),
 					  gettext_noop("Default version"),


[parent: b87163e5f384]