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