Re: improve CREATE EXTENSION error message

> On 29 Nov 2021, at 20:54, Bossart, Nathan <bossartn(at)amazon(dot)com> wrote:
>
> 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?

I haven't given the suggested wording too much thought, but in general that
sounds like a good idea.

--
Daniel Gustafsson https://vmware.com/