Re: FW: Dropped Functions Still Appearing

[Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>]

On Monday 27 November 2006 11:07, brian stapel wrote:
> Thanks for your time. I am using:
> PostgresSQL 8.1.3.PostgresSQL Manager Lite for Windows(3.0.0.2)
> I have several functions that I have dropped, however they still appear in
> my list of functions.  When I click on one of the 'ghost' functions, I
> receive a message: "Function {name} is unavailable in the database.  Push
> the refresh button or F5 to refresh the database tree." If I follow this
> suggestion, the function reappears on refresh.  If I ignore the message,
> the function drops from the list of functions until the next refresh.

I don't know the program that you are using, but it sounds like an 
idiosyncracy of that program.  If you go to psql and drop the function and 
then do \df, do you still see the function?  I would guess not.

Sean