Re: During dump: function not found

oops.  Too late to use that option; but thanks!

Andrew Gould

--- Justin Clift <justin@postgresql.org> wrote:
> 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


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/