Re: User defined functions...

Thank you, all, for your help. It appears that everything is in
schema "public". I found a number of functions that have very similar
names to the ones in his tables so I think he probably dropped these
after he created the tables.

Carol

On Feb 6, 2009, at 2:42 PM, Plugge, Joe R. wrote:

> 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
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin