Thread: FW: Dropped Functions Still Appearing

FW: Dropped Functions Still Appearing

From

brian stapel

Date:

27 November 2006, 15:07:47

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.

Can you help?

Thanks again!

Check the weather nationwide with MSN Search Try it now!

Re: FW: Dropped Functions Still Appearing

From

Sean Davis

Date:

27 November 2006, 15:17:09

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

Re: FW: Dropped Functions Still Appearing

From

brian stapel

Date:

27 November 2006, 15:45:25

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@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

Express yourself with gadgets on Windows Live Spaces Try it!

Re: FW: Dropped Functions Still Appearing

From

Sean Davis

Date:

27 November 2006, 15:59:56

On Monday 27 November 2006 11:45, brian stapel wrote:
> 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?

Yes.  I was referring to the command line interface, psql.  In psql, \df is a
shorthand for listing all the functions available.

Sean

Re: FW: Dropped Functions Still Appearing

From

brian stapel

Date:

27 November 2006, 16:01:03

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.

All-in-one security and maintenance for your PC. Get a free 90-day trial! Learn more!