Re: Stored procedures and schema renames - Mailing list pgsql-general

On 04/10/2014 03:29 PM, Rob Sargent wrote:

> Code for db functions should be a repository. Easy edit and rerun

Well, not necessarily inside the transaction that renames the schema.

I've settled for this inside the transaction (running as a superuser):

    UPDATE pg_proc
       SET proconfig = '{"search_path=symboldb, public"}'
       WHERE pronamespace = (SELECT oid FROM pg_namespace
                             WHERE nspname = 'symboldb');


--
Florian Weimer / Red Hat Product Security Team