Re: User defined functions... - Mailing list pgsql-admin

From Carol Walter
Subject Re: User defined functions...
Date
Msg-id 2138B006-09DD-43C9-AED4-990774F8146B@indiana.edu
Whole thread Raw
In response to Re: User defined functions...  ("Plugge, Joe R." <JRPlugge@west.com>)
List pgsql-admin
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@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
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin


pgsql-admin by date:

Previous
From: "Plugge, Joe R."
Date:
Subject: Re: User defined functions...
Next
From: Josh Moore
Date:
Subject: Postgres will no longer startup