[BUGS] BUG #14700: pg_restore doesn't declare schema in 'create function'statements

The following bug has been logged on the website:

Bug reference:      14700
Logged by:          Pavel Suderevsky
Email address:      psuderevsky@gmail.com
PostgreSQL version: 9.4.5
Operating system:   Centos 7.2
Description:

Hi,

I couldn't find this bug reported here, but maybe community is aware.

When restoring only particular schema from dump with "pg_restore -n" it does
the following:
1. SET search_path = yourschema, pg_catalog
2. CREATE FUNCTION yourfunction()

As a result, if you had forgotten creating yourschema before restoring then
no objects will be restored except your functions, they will be restored in
pg_catalog schema.

These statements must be performed with direct schema reference: CREATE
FUNCTION yourschema.yourfunction().

Reproduced with dumping in 9.4.5 and restoring it to 9.4.5 and 9.6.2.


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