Re: How to ALTER EXTENSION name OWNER TO new_owner ?

Melvin Davidson <melvin6925@gmail.com>

From: Melvin Davidson <melvin6925@gmail.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Scott Marlowe <scott.marlowe@gmail.com>, "Colin 't Hart" <colinthart@gmail.com>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2017-08-09T19:37:23Z
Lists: 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.