Re: Changing schema owner?

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Changing schema owner?
Дата
Msg-id 20040306204924.I32516@zoraida.natserv.net
обсуждение исходный текст
Ответ на Re: Changing schema owner?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Tue, 10 Feb 2004, Tom Lane wrote:

> Francisco Reyes <lists@natserv.com> writes:
> > Is there a way to change a schema owner other than dump/restore?
> > How about changing the nspowner in pg_namespace? Will that do the trick
> > without any negative consecuences?
>
> I think that will work, but experiment in a spare database ...
>             regards, tom lane

I don't think I ever replied to this.
It worked. Changing nspowner in pg_namespace changed the owner of the
schema.

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

Предыдущее
От: "Jim Wilson"
Дата:
Сообщение: Re: 7.4.1 upgrade issues
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 7.4.1 upgrade issues