Thread: During dump: function not found
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/
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
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
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/