Skip site navigation (1) Skip section navigation (2)

Re: Slightly inconsistent behaviour in regproc?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Slightly inconsistent behaviour in regproc?
Date: 2003-10-28 14:40:15
Message-ID: 21924.1067352015@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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 MomjianDate: 2003-10-28 15:01:13
Subject: Re: Open items
Previous:From: Christoph HallerDate: 2003-10-28 14:21:02
Subject: Re: An interisting conundrum where tables have a column called "found"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group