Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)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