Re: improve CREATE EXTENSION error message

Nathan Bossart <bossartn@amazon.com>

From: "Bossart, Nathan" <bossartn@amazon.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Chapman Flack <chap@anastigmatix.net>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>, Daniel Gustafsson <daniel@yesql.se>
Date: 2022-01-11T19:28:42Z
Lists: pgsql-hackers
On 1/11/22, 11:23 AM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> "Bossart, Nathan" <bossartn@amazon.com> writes:
>> Okay, the message looks like this in v5:
>
>>         postgres=# CREATE EXTENSION does_not_exist;
>>         ERROR:  extension "does_not_exist" is not available
>>         DETAIL:  Could not open extension control file "/usr/local/pgsql/share/extension/does_not_exist.control": No such file or directory.
>>         HINT:  The extension must first be installed on the system where PostgreSQL is running.
>
> Nobody complained about that wording, so pushed.

Thanks!

Nathan

Commits

  1. Improve error message for missing extension.