Re: How to ALTER EXTENSION name OWNER TO new_owner ?

From: "Colin 't Hart" <colin(at)sharpheart(dot)org>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to ALTER EXTENSION name OWNER TO new_owner ?
Date: 2017-08-10 13:49:35
Message-ID: CAMon-aRF-q28Sqv+LmxrpM5WWz6gGBN9zsqSWE4JJ-G7H0dzag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Would this be a relatively easy patch for a beginning contributor?

If so, I wouldn't mind having a go.

/Colin

On 9 August 2017 at 21:37, Melvin Davidson <melvin6925(at)gmail(dot)com> wrote:

>
>
> On Wed, Aug 9, 2017 at 3:32 PM, David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>> On Wed, Aug 9, 2017 at 12:26 PM, Melvin Davidson <melvin6925(at)gmail(dot)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.
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Rogerson 2017-08-10 14:28:15 Curious planning decision
Previous Message Julien Rouhaud 2017-08-10 13:12:16 Re: pg_stat_statements -- Historical Query