How to ALTER EXTENSION name OWNER TO new_owner ?
Colin 't Hart <colinthart@gmail.com>
From: "Colin 't Hart" <colinthart@gmail.com>
To: pgsql-general@postgresql.org
Date: 2017-08-09T14:42:37Z
Lists: pgsql-general
Hi, Why does ALTER EXTENSION name OWNER TO new_owner; not exist? I have a bunch of extensions that were installed by a role that I want to drop. So I thought I would do like I do for other object types: ALTER <object_type> name OWNER TO new_owner; But that doesn't exist for extensions. I also can't drop the extension and recreate it because other objects depend on it. What can I do? This is on PostgreSQL 9.3. Thanks, Colin