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@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Joshua D. Drake
Sent: Friday, February 06, 2009 1:36 PM
To: Carol Walter
Cc: pgsql-admin@postgresql.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@jabber.postgresql.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin