Improved error message for CREATE EXTENSION patch...

Sean Chittenden <sean@chittenden.org>

From: Sean Chittenden <sean@chittenden.org>

To: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2013-06-04T18:12:30Z

Lists: pgsql-hackers

Attachments

src-backend-commands-extension.c.patch (application/octet-stream) patch
(unnamed) (text/plain)

I ran in to the following situation:

> SET search_path = ENOENT, also_does_not_exist;
> CREATE EXTENSION pg_repack;
> ERROR:  XX000: there is no default creation target
> LOCATION:  CreateExtension, extension.c:1395

Which left me checking out the source code to figure out exactly what the problem was. Attached is an improved error message:

> "ERROR:  XX000: no schemas in search_path are available for CREATE EXTENSION"

-sc