Re: Changing owner of pg_toast tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Changing owner of pg_toast tables
Дата
Msg-id 29515.1233243968@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 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:
> I'm trying to drop a role that is no longer being used. However the role
> has 4 dependencies which are all pg_toast tables. How can I change the
> owner of those pg_toast tables so I can drop the role?

I guess the interesting question to me is what happened to the tables
those toast tables are/were attached to?  They should have the same
owners as their parent tables.  What PG version is this exactly?

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Text search segmentation fault
Следующее
От: Richard Broersma
Дата:
Сообщение: Re: Pet Peeves?