Re: FW: Dropped Functions Still Appearing

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: FW: Dropped Functions Still Appearing
Date: 2006-11-27 16:16:59
Message-ID: 200611271116.59953.sdavis2@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message brian stapel 2006-11-27 16:45:01 Re: FW: Dropped Functions Still Appearing
Previous Message brian stapel 2006-11-27 16:07:41 FW: Dropped Functions Still Appearing