Re: During dump: function not found

Hi Andrew,

These functions were indeed created by PgAdmin.  It seems to create
tables, functions, triggers and views (maybe rules too, not sure) going
by the name pgadmin_xxx and pga_xxx

I'm pretty sure from looking at PgAdmin 7.1.0 recently it has a menu
option to remove it's tables and other constructs from a target database
by itself.  You might just want to run that instead of doing it
yourself/

:-)

Regards and best wishes,

Justin Clift


Andrew Gould wrote:
>
> During a pg_dump, I got the following messages:
>
> 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?  Will these
> messages haunt me down the road in other ways?
>
> 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.
>
> Thanks,
>
> Andrew Gould
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
     - Indira Gandhi