> On 3 Jun 2021, at 11:53, tushar <tushar.ah...@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/