Re: FW: Dropped Functions Still Appearing

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(at)mail(dot)nih(dot)gov> To: pgsql-novice(at)postgresql(dot)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
http://discoverspaces.live.com?source=hmtag1&loc=us