Re: Slightly inconsistent behaviour in regproc? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Slightly inconsistent behaviour in regproc?
Date
Msg-id 21924.1067352015@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slightly inconsistent behaviour in regproc?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Basically, my question is why ::regproc alone always addes the catalogue 
> qualification in this case?

regproc adds the schema if the name would be ambiguous without it (or
not visible at all).  In these cases, the function name is still
ambiguous with the schema :-( ... but there's nothing regproc can do
about that, since it's not chartered to emit function arguments.
Use regprocedure instead if you don't want to see schema names.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Open items
Next
From: Bruce Momjian
Date:
Subject: Re: Open items