Re: improve CREATE EXTENSION error message

From: "Bossart, Nathan" <bossartn(at)amazon(dot)com>
To: Chapman Flack <chap(at)anastigmatix(dot)net>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Daniel Gustafsson <daniel(at)yesql(dot)se>
Subject: Re: improve CREATE EXTENSION error message
Date: 2021-11-30 00:12:31
Message-ID: 2D9094F2-BA62-4DCE-A357-9433B7AAA225@amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11/29/21, 3:47 PM, "Chapman Flack" <chap(at)anastigmatix(dot)net> wrote:
> My leaning is generally to use %m and therefore the exact OS message
> in the detail, but I don't claim to speak for the project style on that.

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.

Nathan

Attachment Content-Type Size
v5-0001-Improve-CREATE-EXTENSION-error-message.patch application/octet-stream 1.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andy Fan 2021-11-30 00:36:42 Re: Can I assume relation would not be invalid during from ExecutorRun to ExecutorEnd
Previous Message Tom Lane 2021-11-30 00:08:26 Re: Correct handling of blank/commented lines in PSQL interactive-mode history