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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: matthew(dot)baynham(at)gmail(dot)com
Subject: BUG #17939: CREATE EXTENSION pltcl; looks in the wrong folder
Date: 2023-05-23 06:47:19
Message-ID: 17939-53b96d9717b00311@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17939
Logged by: Matthew Baynham
Email address: matthew(dot)baynham(at)gmail(dot)com
PostgreSQL version: 15.2
Operating system: Ubuntu 2304
Description:

I install pltcl with the following command...
sudo apt-get install postgresql-pltcl

Then I need to create the extension with...
CREATE EXTENSION pltcl;

So now I have version 15.2 of PostgreSQL and the apt-get command did it's
job correctly and installed into...
matthew(at)matthew-QEMU:~$ cd "/usr/share/postgresql/15/extension"
matthew(at)matthew-QEMU:/usr/share/postgresql/15/extension$ ls plt*
pltcl--1.0.sql pltcl.control pltclu--1.0.sql pltclu.control

However the create extension command is looking in the wrong folder.
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))
Type "help" for help.

matthew=# CREATE EXTENSION pltcl;
ERROR: could not open extension control file
"/usr/share/postgresql/14/extension/pltcl.control": No such file or
directory

So when the version I have is definitely version 15.2 it looks for
extensions in the folder for version 14.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexey Kachalin 2023-05-23 07:00:11 Prepared SQL name collision. The name implicitly is truncated by NAMEDATALEN
Previous Message Wei Wang (Fujitsu) 2023-05-23 04:11:29 RE: Logical Replica ReorderBuffer Size Accounting Issues