Re: Fixing broken permissions for deleted user
От | Justin Pasher |
---|---|
Тема | Re: Fixing broken permissions for deleted user |
Дата | |
Msg-id | 000901c79901$bd6b95b0$020aa8c0@taz обсуждение исходный текст |
Ответ на | Re: Fixing broken permissions for deleted user (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Fixing broken permissions for deleted user
|
Список | pgsql-general |
> -----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
В списке pgsql-general по дате отправления: