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 <fwei...@redhat.com> wrote: > > 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 on > function definition time, which does not address this issue either. > > If backend code changes are required, what would be a reasonable way to > approach this? Would adding a CURRENT_SCHEMA pseudo-schema which can be used > in stored procedures work? > > -- > Florian Weimer / Red Hat Product Security Team > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
