> On 3 Jun 2021, at 11:53, tushar <tushar.ahuja@enterprisedb.com> wrote:
> In one of my testing scenario, i found pg_upgrade is failed for 'plpgsql_call_handler' handle
This isn't really a pg_upgrade issue but a pg_dump issue. The handler, inline
nd validator functions will be looked up among the functions loaded into
pg_dump and included in the CREATE LANGUAGE statement. However, iff they are
in pg_catalog then they wont be found (pg_catalog is excluded in getFuncs) and
a bare CREATE LANGUAGE statement will be emitted. This bare statement will
then be interpreted as CREATE EXTENSION.
This is intentional since the language template work in 8.1, before then
pg_dump would look up support functions in pg_catalog.
--
Daniel Gustafsson https://vmware.com/
