Re: Changing owner of pg_toast tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Changing owner of pg_toast tables
Дата
Msg-id 8087.1233256297@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Changing owner of pg_toast tables  (Mark Styles <postgres@lambic.co.uk>)
Ответы Re: Changing owner of pg_toast tables
Список pgsql-general
Mark Styles <postgres@lambic.co.uk> writes:
> Thanks, I managed to clear out the offending dependencies. relowner was
> actually set correctly, but the pg_shdepend records were wrong.

Hmm ... what actually was in the pg_shdepend entries?

Given the way the code works, this could be explained by a corrupt index
for pg_shdepend (which could cause it to fail to find the entries it
should've deleted).  But I don't see how that would lead to an "OID not
found" type of message.  Also, if you did get an error, that should've
rolled back the whole thing.  So I'm still baffled.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Changing owner of pg_toast tables
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Pet Peeves?