Re: Schema name of function

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: John Hansen <john(at)geeknet(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Schema name of function
Date: 2005-02-14 18:12:55
Message-ID: 20050214181255.GA28075@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Feb 14, 2005 at 11:11:53AM -0500, Tom Lane wrote:
>
> In C, it'd be a lot easier (and faster) to do a couple of SearchSysCache
> calls than to use SPI to get those rows.

The following appears to work -- does it look right, aside from the
missing error checking?

tuple = SearchSysCache(PROCOID,
ObjectIdGetDatum(fcinfo->flinfo->fn_oid),
0, 0, 0);
nsoid = SysCacheGetAttr(PROCOID, tuple,
Anum_pg_proc_pronamespace, &isnull);
schemaname = get_namespace_name(nsoid);
ReleaseSysCache(tuple);

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Fuhr 2005-02-14 18:32:53 Re: getting oid of function
Previous Message pgsql 2005-02-14 18:02:05 Re: Help me recovering data