Re: improve CREATE EXTENSION error message

Nathan Bossart <bossartn@amazon.com>

From: "Bossart, Nathan" <bossartn@amazon.com>
To: Daniel Gustafsson <daniel@yesql.se>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2021-11-29T21:39:14Z
Lists: pgsql-hackers

Attachments

On 11/29/21, 1:32 PM, "Daniel Gustafsson" <daniel@yesql.se> wrote:
>> On 29 Nov 2021, at 22:02, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I'm not quite satisfied with the "on the system" wording, but I'm
>> not sure of what would be better.  I agree that we can't just say
>> "is not installed", because people will confuse that with whether
>> it is installed within the database.
>
> That's a good point, the hint is targeting users who might not even know that
> an extension needs to be physically and separately installed on the machine
> before it can be installed in their database; so maybe using "installed" here
> isn't entirely helpful at all.  That being said I'm at a loss for a more
> suitable word, "available" perhaps?

I was just thinking the same thing.  I used "available" in v2, which
is attached.

Nathan

Commits

  1. Improve error message for missing extension.