Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group