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 = '{
Code for db functions should be a repository. Easy edit and rerun
Sent from my iPhone
> On Apr 10, 2014, at 6:19 AM, Florian Weimer wrote:
>
> I would like to rename schemas without breaking the stored procedures in
> them. Currently, this does not work if the stored procedure definition
> c
I would like to rename schemas without breaking the stored procedures in
them. Currently, this does not work if the stored procedure definition
contains a schema self-reference because that does not get renamed. I
tried "SET search_path FROM CURRENT", but that seems to expand the
search path
