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
