Re: BUG #17939: CREATE EXTENSION pltcl; looks in the wrong folder

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: matthew(dot)baynham(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17939: CREATE EXTENSION pltcl; looks in the wrong folder
Date: 2023-05-23 07:04:19
Message-ID: 20230523070419.3ztesptgw3m6ch77@jrouhaud
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, May 23, 2023 at 06:47:19AM +0000, PG Bug reporting form wrote:
>
> matthew(at)matthew-QEMU:~$ psql -d matthew -U matthew
> psql (15.2 (Ubuntu 15.2-1), server 14.7 (Ubuntu 14.7-0ubuntu0.22.10.1))
> [...]
> So when the version I have is definitely version 15.2 it looks for
> extensions in the folder for version 14.

The *client* version is definitely 15.2, but as psql told when you opened the
connection you're actually connected on a 14.7 *server*, so postgres is
searching in the correct folder.

You can look at e.g. pg_lsclusters to see what instances are currently setup,
and of which version.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2023-05-23 08:48:40 Re: Need Support to Upgrade from 13.6 to 15.3
Previous Message Alexey Kachalin 2023-05-23 07:00:11 Prepared SQL name collision. The name implicitly is truncated by NAMEDATALEN