Re: pg_get_triggerdef does not use the schema qualified procedure name

2019-09-26 Thread Tom Lane
AJ Welch writes: > I noticed that pg_get_triggerdef doesn't seem to use the schema qualified > name of procedures/functions. Is it supposed to? Is there a way to get it > to? Generally the policy of such functions is to schema-qualify names that wouldn't be found in the current search_path. So y

pg_get_triggerdef does not use the schema qualified procedure name

2019-09-26 Thread AJ Welch
Hi, I noticed that pg_get_triggerdef doesn't seem to use the schema qualified name of procedures/functions. Is it supposed to? Is there a way to get it to? z1h=# \x auto Expanded display is used automatically. z1h=# select tg.tgname "name", nsp.nspname "schema", cls.relname table_name, pg_