Re: Dealing with table names in functions

On Thu, 2007-03-22 at 09:40 -0400, Alvaro Herrera wrote:
> Pass the optionally qualified name and cast it to regclass. It will
> work correctly when the name is not qualified, applying search_path,
> and it will also work when the name is qualified.

Is there a way to get names that are always qualified, irrespective of
the search_path? Once one has the oid, it's an easy function to write,
but I suspect this machinery already exists.

For example, I'd like the hypothetical cast:
rkh(at)csb-dev=> set search_path = 'unison';
SET

rkh(at)csb-dev=> select 'pseq'::regclass::oid::FQregclass;
regclass
----------
unison.pseq
(1 row)

-Reece

--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
./universe -G 6.672e-11 -e 1.602e-19 -protonmass 1.673e-27 -uspres bush
kernel warning: universe consuming too many resources. Killing.
universe killed due to catastrophic leadership. Try -uspres carter.