Horton
Menu

Re: How to ALTER EXTENSION name OWNER TO new_owner ?

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Melvin Davidson <melvin6925@gmail.com>, "Colin 't Hart" <colinthart@gmail.com>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2017-08-09T17:37:47Z
Lists: pgsql-general 
Scott Marlowe <scott.marlowe@gmail.com> writes:
> Seems like something that should be handled by alter doesn't it?

I have some vague memory that we intentionally didn't implement
ALTER EXTENSION OWNER because we were unsure what it ought to do
about ownership of objects belonging to the extension.  If the answer
is "nothing" then it wouldn't be hard to add such a statement.

			regards, tom lane