Re: Fixing broken permissions for deleted user

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Fixing broken permissions for deleted user
Дата
Msg-id 18888.1179381034@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Fixing broken permissions for deleted user  ("Justin Pasher" <justinp@newmediagateway.com>)
Ответы Re: Fixing broken permissions for deleted user  ("Justin Pasher" <justinp@newmediagateway.com>)
Список 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 по дате отправления:

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: cube operations
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Vacuum non-clustered tables only