Re: User defined functions...

Does your user have their own SCHEMA, if so you will have to :

set search_path to SCHEMA_NAME

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Joshua D. Drake
Sent: Friday, February 06, 2009 1:36 PM
To: Carol Walter
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] User defined functions...

On Fri, 2009-02-06 at 14:30 -0500, Carol Walter wrote:
> Hello,
>
> Should all functions be visible when I issue the command
> citesrch=# select * from pg_proc;
> including those that are user defined?
> My user has several functions in his database that I don't see there.

> I don't know if I'm looking in the wrong place or he dropped them
> after the table was created.

It will show per database. So if you want to see his, connect to his
database.

Joshua D. Drake

>
> Carol
>
>
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997