Superuser can execute but not view function

From: "Mike G(dot)" <mike(at)thegodshalls(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Superuser can execute but not view function
Date: 2005-08-25 20:11:03
Message-ID: 20050825201103.GB10538@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I have a function that exists (I can call it and execute it) but does not appear in pgadmin. I issued an Alter function owner to postgres (the super user) which was successful to check if it was a permission problem, refreshed pgadmin and it still does appear.

I then issued a select * from pg_proc and the function does not appear in this table. Should it not be listed in this table?

The function is named surveys_2004.update_total_sent_by_consultant_table(date,date)

This database started out in 7.3 under cygwin and is now 8.03 under windows natively.

I would like to access the function above and modify it.

Ideas on how I can get it to appear in pgadmin or how I could use psql to dump the function definition?

Mike

----- End forwarded message -----

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Saranya Sivakumar 2005-08-25 20:25:01 query optimization
Previous Message Charley L. Tiggs 2005-08-25 20:10:22 Re: Selective authentication?