From: | brian stapel <brians_224(at)hotmail(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: FW: Dropped Functions Still Appearing |
Date: | 2006-11-27 16:45:01 |
Message-ID: | BAY107-W7C3244C77F8BB16FAEBCFA1E60@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2006-11-27 16:59:23 | Re: FW: Dropped Functions Still Appearing |
Previous Message | Sean Davis | 2006-11-27 16:16:59 | Re: FW: Dropped Functions Still Appearing |