Re: FW: Dropped Functions Still Appearing

From: brian stapel <brians_224(at)hotmail(dot)com>
To: <sdavis2(at)mail(dot)nih(dot)gov>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: FW: Dropped Functions Still Appearing
Date: 2006-11-27 17:00:51
Message-ID: BAY107-W9BE82316103ED44069FFDA1E60@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Sean was correct - its a problem with the GUI I used to drop the functions. If I drop the functions from pgAdmin III - the function drop as they should and never reappear in the list.

Thanks for your time.

> 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
_________________________________________________________________
All-in-one security and maintenance for your PC.  Get a free 90-day trial!
http://www.windowsonecare.com/purchase/trial.aspx?sc_cid=wl_wlmail

Browse pgsql-novice by date

  From Date Subject
Next Message Jim Nasby 2006-11-28 01:12:27 Re: Benchmarking PostgreSQL against others on Windows?
Previous Message Sean Davis 2006-11-27 16:59:23 Re: FW: Dropped Functions Still Appearing