From: | Matt Warner <matt(at)warnertechnology(dot)com> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unprivileged access to pgsql functions? |
Date: | 2011-03-04 22:08:14 |
Message-ID: | AANLkTimzOGoKcHtZGaCyDRadeENrh+bkrXnmNoxQkbFK@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Mar 4, 2011 at 2:03 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> On 03/04/11 1:57 PM, Matt Warner wrote:
>
>> Not sure. I believe public and pg_catalog are in the path by default. Most
>> of the create function declarations prepend pg_catalog, and I believe I saw
>> somewhere that pg_catalog is the default. But I may be misunderstanding
>> that...
>>
>
> CREATE FUNCTION nvl(anyelement, anyelement)
> RETURNS anyelement
> AS '$libdir/orafunc','ora_nvl'
> LANGUAGE C IMMUTABLE;
>
> doesn't specify any schema, so that function is created in the current
> schema in the current database
>
>
>
Yes, my bad for thinking of this as an Oracle schema as opposed to a
different database.
From | Date | Subject | |
---|---|---|---|
Next Message | Sebastien Boisvert | 2011-03-04 23:15:23 | Significance of numbers in server errors? |
Previous Message | John R Pierce | 2011-03-04 22:03:49 | Re: Unprivileged access to pgsql functions? |