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