tushar <tushar.ah...@enterprisedb.com> writes:
> postgres=# CREATE LANGUAGE alt_lang1 HANDLER plpgsql_call_handler;

pg_dump doesn't really support that scenario, and I don't feel any
great need to make it do so.  Per the comment in dumpProcLang:

         * Try to find the support function(s).  It is not an error if we don't
         * find them --- if the functions are in the pg_catalog schema, as is
         * standard in 8.1 and up, then we won't have loaded them. (In this case
         * we will emit a parameterless CREATE LANGUAGE command, which will
         * require PL template knowledge in the backend to reload.)

So the assumption is basically that PLs that don't have pg_pltemplate
entries will not keep their support functions in pg_catalog.  I think
there are exceptions to handle languages+support functions that are
wrapped into extensions ... but you didn't do that either.

                        regards, tom lane

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to