Hello Sean -
Thanks for your quick reply!
When you say - "goto psql and drop the function", are you talking about a specific GUI or are you referring to a command prompt interface? Everything I've done in postgresql thus far has been through the PostgresSQL Manager Lite GUI interface.
Can you give me more details regarding the '/df' command?
> From: sdavis2@mail.nih.gov
> To: pgsql-novice@postgresql.org
> Subject: Re: [NOVICE] FW: Dropped Functions Still Appearing
> Date: Mon, 27 Nov 2006 11:16:59 -0500
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
Express yourself with gadgets on Windows Live Spaces
Try it!
