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@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
All-in-one security and maintenance for your PC. Get a free 90-day trial!
Learn more!