improve CREATE EXTENSION error message

From: "Bossart, Nathan" <bossartn(at)amazon(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: improve CREATE EXTENSION error message
Date: 2021-11-29 19:54:56
Message-ID: 3950D56A-4E47-48E7-BF9B-F5F22E268BE7@amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers,

Currently, if you attempt to use CREATE EXTENSION for an extension
that is not installed, you'll see something like the following:

postgres=# CREATE EXTENSION does_not_exist;
ERROR: could not open extension control file "/usr/local/pgsql/share/extension/does_not_exist.control": No such file or directory

I suspect this ERROR message is confusing for novice users, so perhaps
we should add a HINT. With the attached patch, you'd see the
following:

postgres=# CREATE EXTENSION does_not_exist;
ERROR: could not open extension control file "/usr/local/pgsql/share/extension/does_not_exist.control": No such file or directory
HINT: This typically indicates that the specified extension is not installed on the system.

Thoughts?

Nathan

Attachment Content-Type Size
v1-0001-Improve-CREATE-EXTENSION-error-message.patch application/octet-stream 882 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Guillaume Lelarge 2021-11-29 19:58:17 Re: Lots of memory allocated when reassigning Large Objects
Previous Message Tom Lane 2021-11-29 19:39:14 Re: Lots of memory allocated when reassigning Large Objects