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
