Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ? - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?
Date
Msg-id CAKFQuwYdj2LqjOCpyyd+ycOuc=LBNurVuMV166_rxxsHHUj5Qw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view
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.
​

pgsql-general by date:

Previous
From: Peter Hunčár
Date:
Subject: Re: [GENERAL] Multixact members limit exceeded
Next
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?