Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_get_triggerdef does not use the schema qualified procedure name - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_get_triggerdef does not use the schema qualified procedure name
Date
Msg-id 12993.1569538051@sss.pgh.pa.us
Whole thread Raw
In response to pg_get_triggerdef does not use the schema qualified procedure name  (AJ Welch <awelch0100@gmail.com>)
List pgsql-general
Tree view 
AJ Welch <awelch0100@gmail.com> 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 you could get what
you want by setting a restrictive search_path beforehand, maybe just ''.

            regards, tom lane

pgsql-general by date:

Previous
From: AJ Welch
Date:
Subject: pg_get_triggerdef does not use the schema qualified procedure name
Next
From: keisuke kuroda
Date:
Subject: pg12 rc1 on CentOS8 depend python2