pgsql: Provide better message when CREATE EXTENSION can't find a target

Started by Tom Laneabout 13 years ago1 messagescomitters

tgl@sss.pgh.pa.us

about 13 years ago

Provide better message when CREATE EXTENSION can't find a target schema.

The new message (and SQLSTATE) matches the corresponding error cases in
namespace.c.

This was thought to be a "can't happen" case when extension.c was written,
so we didn't think hard about how to report it. But it definitely can
happen in 9.2 and later, since we no longer require search_path to contain
any valid schema names. It's probably also possible in 9.1 if search_path
came from a noninteractive source. So, back-patch to all releases
containing this code.

Per report from Sean Chittenden, though this isn't exactly his patch.

Branch
------
REL9_1_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/f94979f618abffb63cad2266f39db8beeeb18afc

Modified Files
--------------
src/backend/commands/extension.c | 10 +++++++---
1 file changed, 7 insertions(+), 3 deletions(-)

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers