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

Re: FW: Dropped Functions Still Appearing

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

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2006-11-27 16:59:23
Subject: Re: FW: Dropped Functions Still Appearing
Previous:From: Sean DavisDate: 2006-11-27 16:16:59
Subject: Re: FW: Dropped Functions Still Appearing

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