Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?
Дата
Msg-id CANu8FizXD8g-i=5exAP=0sUUD-U5vgWRijUc3M-WhGanOA87qQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?
Список pgsql-general
Дерево обсуждения


On Wed, Aug 9, 2017 at 3:32 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, Aug 9, 2017 at 12:26 PM, Melvin Davidson <melvin6925@gmail.com> wrote:
>I'm am wondering whether "REASSIGNED OWNED" needs fixing as well

Possibly, but as the op is on 9.3, it is not available to him.

​You should check the docs again...​
 
I would also argue that since "OWNER TO new_owner" is available in all other ALTER object statements, it is an omission and should be
included for extenstions as well..

​As am I, but omission or not I don't recall that we've ever back-patched new SQL grammar.

David J.
​
>You should check the docs again...​
Yes, you are correct, it is in 9.3

>I don't recall that we've ever back-patched new SQL grammar.
I am not saying back patch, I am saying an enhancement for version 10 or 11.

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [GENERAL] Multixact members limit exceeded