]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Add paths of extensions to pg_available_extensions
authorAndrew Dunstan <andrew@dunslane.net>
Thu, 1 Jan 2026 17:11:37 +0000 (12:11 -0500)
committerAndrew Dunstan <andrew@dunslane.net>
Thu, 1 Jan 2026 17:13:59 +0000 (12:13 -0500)
commitf3c9e341cdf167ae3378e74e770558e81f9aa48e
tree4e5a1bbf2812cd2b4fbd370e50eb1a2a9bf283b4
parent85d5bd308bf5dc3068a4c28aa0f12cc22272f789
Add paths of extensions to pg_available_extensions

Add a new "location" column to the pg_available_extensions and
pg_available_extension_versions views, exposing the directory where
the extension is located.

The default system location is shown as '$system', the same value
that can be used to configure the extension_control_path GUC.

User-defined locations are only visible for super users, otherwise
'<insufficient privilege>' is returned as a column value, the same
behaviour that we already use in pg_stat_activity.

I failed to resist the temptation to do a little extra editorializing of
the TAP test script.

Catalog version bumped.

Author: Matheus Alcantara <mths.dev@pm.me>
Reviewed-By: Chao Li <li.evan.chao@gmail.com>
Reviewed-By: Rohit Prasad <rohit.prasad@arm.com>
Reviewed-By: Michael Banck <mbanck@gmx.net>
Reviewed-By: Manni Wood <manni.wood@enterprisedb.com>
Reviewed-By: Euler Taveira <euler@eulerto.com>
Reviewed-By: Quan Zongliang <quanzongliang@yeah.net>
doc/src/sgml/system-views.sgml
src/backend/catalog/system_views.sql
src/backend/commands/extension.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.dat
src/test/modules/test_extensions/t/001_extension_control_path.pl
src/test/regress/expected/rules.out
src/tools/pgindent/typedefs.list