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
In response to
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 2003-10-28 15:01:13|
|Subject: Re: Open items|
|Previous:||From: Christoph Haller||Date: 2003-10-28 14:21:02|
|Subject: Re: An interisting conundrum where tables have a column called "found"|