Re: During dump: function not found - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: During dump: function not found
Date
Msg-id Pine.LNX.4.30.0108221810580.679-100000@peter.localdomain
Whole thread Raw
In response to During dump: function not found  (Andrew Gould <andrewgould@yahoo.com>)
List pgsql-general
Andrew Gould writes:

> Notice: function "pgadmin_get_rows" is not dumped.
> Reason: return type name (oid 87589805) not found.
> Notice: function "pgadmin_get_sequence" is not dumped.
> Reason: return type name (oid 87589772) not found.
>
> Does this simply mean that these functions will not be
> available if I restore from the dump file?

Yes.

> Will these messages haunt me down the road in other ways?

If something depended on the named functions...

What you did was drop the return type of the function (which used to have
the shown oid).  Therefore the function is already useless anyway.

> I'm assuming (dangerous, I know) that these functions
> were created by PgAdmin rather than being a part of
> PostgreSQL.  I deleted all tables and views named
> pgadmin* and am trying to weed out everything created
> by PgAdmin.

Maybe PgAdmin could provide a drop script for that?

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: "Paul C."
Date:
Subject: Re: FTI is really really slow; what am I doing wrong?
Next
From: Bruno Wolff III
Date:
Subject: Re: FTI is really really slow; what am I doing wrong?