Re: Fixing broken permissions for deleted user

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Justin Pasher" <justinp(at)newmediagateway(dot)com>
Cc: "'Richard Huxton'" <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Fixing broken permissions for deleted user
Date: 2007-05-17 05:50:34
Message-ID: 18888.1179381034@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Justin Pasher" <justinp(at)newmediagateway(dot)com> writes:
> OK. After playing around with this extensively I FINALLY got the permissions
> remove (from anything I can see).
> ...
> The table owner is also a different user from user id 101. However, it still
> gives me the same complaint.

> pg_dump: WARNING: owner of data type "menu_items" appears to be invalid
> pg_dump: WARNING: owner of data type "pg_toast_47831338" appears to be
> invalid

> I do notice the error says "owner of data type", so perhaps it is referring
> to something else besides the table?

Yeah, the pg_type entry for the table's rowtype.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-05-17 06:10:56 Re: Vacuum non-clustered tables only
Previous Message Oleg Bartunov 2007-05-17 05:15:09 Re: cube operations