public inbox for [email protected]
help / color / mirror / Atom feedAdding clarification on extension_control_path when extension is present in multiple folders
2+ messages / 2 participants
[nested] [flat]
* Adding clarification on extension_control_path when extension is present in multiple folders
@ 2025-09-05 13:53 Pierrick <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Pierrick @ 2025-09-05 13:53 UTC (permalink / raw)
To: [email protected]
When playing with the new GUC extension_control_path, I found that the
paths are evaluated one by one
(like search_path)and if an extension is present in multiple paths, only
the on in the first path
will be considered.I think this is totally fine, but I'd like to adda
documentation patch to explain
this (attached file).
What do you think ?
Pierrick,
Here is an example to understand that I can only create extension in
version 2.0.
postgres=# show extension_control_path ;
extension_control_path
-----------------------------------------------------------------------------
$system:/extensions/meilleureextension/share:/extensions/monextension/share
(1 row)
postgres=# select * from pg_available_extensions where name like '%mon%';
name | default_version | installed_version | comment
--------------+-----------------+-------------------+---------------
monextension | 2.0 | | Meilleure
monextension | 1.0 | | Mon extension
(2 rows)
postgres=# select * from pg_available_extensions where name like '%mon%';
name | default_version | installed_version | comment
--------------+-----------------+-------------------+---------------
monextension | 2.0 | | Meilleure
monextension | 1.0 | | Mon extension
(2 rows)
postgres=# create extension monextension version "1.0" ;
ERROR: extension "monextension" has no installation script nor update
path for version "1.0"
postgres=# create extension monextension ;
CREATE EXTENSION
postgres=# select * from pg_available_extensions where name like '%mon%';
name | default_version | installed_version | comment
--------------+-----------------+-------------------+---------------
monextension | 2.0 | 2.0 | Meilleure
monextension | 1.0 | 2.0 | Mon extension
(2 rows)
Attachments:
[text/x-patch] 0001-Add-clarification-on-extension_control_path.patch (950B, 2-0001-Add-clarification-on-extension_control_path.patch)
download | inline diff:
From d04af9866d9eddea04b046005df3b2cdc99b28ec Mon Sep 17 00:00:00 2001
From: Pierrick Chovelon <[email protected]>
Date: Fri, 5 Sep 2025 15:36:20 +0200
Subject: [PATCH] Add clarification on extension_control_path
---
doc/src/sgml/config.sgml | 6 ++++++
1 file changed, 6 insertions(+)
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index 0a4b3e55ba5..752d18dec53 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -11079,6 +11079,12 @@ extension_control_path = '/usr/local/share/postgresql:$system'
dynamic_library_path = '/usr/local/lib/postgresql:$libdir'
</programlisting>
</para>
+
+ <para>
+ This variable specifies the order in which extensions are searched when created.
+ If an extension is present in multiple paths, only the first path that contains
+ extension's files will be used.
+ </para>
</listitem>
</varlistentry>
--
2.43.0
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Adding clarification on extension_control_path when extension is present in multiple folders
@ 2025-09-10 12:39 Matheus Alcantara <[email protected]>
parent: Pierrick <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Matheus Alcantara @ 2025-09-10 12:39 UTC (permalink / raw)
To: Pierrick <[email protected]>; [email protected]
On Fri Sep 5, 2025 at 10:53 AM -03, Pierrick wrote:
> When playing with the new GUC extension_control_path, I found that the
> paths are evaluated one by one
> (like search_path)and if an extension is present in multiple paths, only
> the on in the first path
> will be considered.I think this is totally fine, but I'd like to adda
> documentation patch to explain
> this (attached file).
>
> What do you think ?
>
Hi, thanks for working on this!
Just to mention that I have this on my plate, I'm just waiting for a
conclusion on discussion at [1] so that I can make a proper review here.
Thanks!
[1] https://www.postgresql.org/message-id/[email protected]
--
Matheus Alcantara
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-09-10 12:39 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-09-05 13:53 Adding clarification on extension_control_path when extension is present in multiple folders Pierrick <[email protected]>
2025-09-10 12:39 ` Matheus Alcantara <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox