Re: Fixing broken permissions for deleted user

From: "Justin Pasher" <justinp(at)newmediagateway(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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-18 04:05:13
Message-ID: 000901c79901$bd6b95b0$020aa8c0@taz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-05-18 04:15:30 Re: Fixing broken permissions for deleted user
Previous Message Robert James 2007-05-18 03:47:26 Postgres / Jaro Winkler fuzzy string matching