[GENERAL] pg_dump warings

2006-04-30 Thread Rick Ellis
I did something foolish and now I'm getting warnings every time pg_dump runs (hourly from cron). Anybody have a suggestion on how to fix this? pg_dump: WARNING: owner of data type "accountuser" appears to be invalid pg_dump: WARNING: owner of data type "adminuser" appears to be invalid pg_dump: WA

Re: [GENERAL] pg_dump warings

2006-04-30 Thread Devrim GUNDUZ
Hi, On Sun, 2006-04-30 at 21:42 +, Rick Ellis wrote: > I did something foolish and now I'm getting warnings every time > pg_dump runs (hourly from cron). Anybody have a suggestion on how > to fix this? Create the user again with the same userid (I mean revert what you did). You can get this i

Re: [GENERAL] pg_dump warings

2006-04-30 Thread Rick Ellis
In article <[EMAIL PROTECTED]>, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote: >Create the user again with the same userid (I mean revert what you did). >You can get this info from pg_tables and pg_authid(or pg_shadow, >depending on your PostgreSQL version). It turned out to be some tables had been cre