improve CREATE EXTENSION error message - Mailing list pgsql-hackers

From Bossart, Nathan
Subject improve CREATE EXTENSION error message
Date
Msg-id 3950D56A-4E47-48E7-BF9B-F5F22E268BE7@amazon.com
Whole thread Raw
Responses Re: improve CREATE EXTENSION error message
Re: improve CREATE EXTENSION error message
List 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
suchfile 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
suchfile or directory
 
        HINT:  This typically indicates that the specified extension is not installed on the system.

Thoughts?

Nathan


Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Lots of memory allocated when reassigning Large Objects
Next
From: Guillaume Lelarge
Date:
Subject: Re: Lots of memory allocated when reassigning Large Objects