Re: Fixing broken permissions for deleted user

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Thursday, May 17, 2007 12:51 AM
> To: Justin Pasher
> Cc: 'Richard Huxton'; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Fixing broken permissions for deleted user
>
> "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

Perfect. Just was I was looking for. So is it safe to actually run an update
on the pg_catalog.pg_type.typowner column to change the user id from 101 to
another existing user id without causing any other database weirdness?

Justin Pasher