Re: FW: Dropped Functions Still Appearing - Mailing list pgsql-novice

From Sean Davis
Subject Re: FW: Dropped Functions Still Appearing
Date
Msg-id 200611271116.59953.sdavis2@mail.nih.gov
Whole thread Raw
In response to FW: Dropped Functions Still Appearing  (brian stapel <brians_224@hotmail.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: brian stapel
Date:
Subject: FW: Dropped Functions Still Appearing
Next
From: brian stapel
Date:
Subject: Re: FW: Dropped Functions Still Appearing