Re: improve CREATE EXTENSION error message - Mailing list pgsql-hackers

From Bossart, Nathan
Subject Re: improve CREATE EXTENSION error message
Date
Msg-id C8C4CA43-C6A6-41B3-9328-C75E8A1A2093@amazon.com
Whole thread Raw
In response to Re: improve CREATE EXTENSION error message  (Chapman Flack <chap@anastigmatix.net>)
List pgsql-hackers
On 11/29/21, 2:32 PM, "Chapman Flack" <chap@anastigmatix.net> wrote:
> If it were me, I would combine that DETAIL and HINT as one larger HINT,
> and use DETAIL for specific details about what actually happened (such
> as the exact filename sought and the %m).
>
> The need for those details doesn't go away; they're still what you need
> when what went wrong is some other freak occurrence the hint doesn't
> explain.

How's this?

        postgres=# CREATE EXTENSION does_not_exist;
        ERROR:  extension "does_not_exist" is not available
        DETAIL:  Extension control file "/usr/local/pgsql/share/extension/does_not_exist.control" does not exist.
        HINT:  The extension must first be installed on the system where PostgreSQL is running.  The
pg_available_extensionsview lists the available extensions.
 

Nathan


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: improve CREATE EXTENSION error message
Next
From: Tom Lane
Date:
Subject: Re: SSL Tests for sslinfo extension