Re: Fixing broken permissions for deleted user - Mailing list pgsql-general

From Tom Lane
Subject Re: Fixing broken permissions for deleted user
Date
Msg-id 18888.1179381034@sss.pgh.pa.us
Whole thread Raw
In response to Re: Fixing broken permissions for deleted user  ("Justin Pasher" <justinp@newmediagateway.com>)
Responses Re: Fixing broken permissions for deleted user
List pgsql-general
"Justin Pasher" <justinp@newmediagateway.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

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: cube operations
Next
From: Richard Huxton
Date:
Subject: Re: Vacuum non-clustered tables only