Horton
Menu

Re: How to ALTER EXTENSION name OWNER TO new_owner ?

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Melvin Davidson <melvin6925@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:32:49Z
Lists: pgsql-general 
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.
​