Hello,

I discovered that extensions have owners (pg_extension.extowner).

The pgadmin4 schema diff ... well er, kind of tried to report to me that the 
owners differ (https://redmine.postgresql.org/issues/7145).

This seems to be badly supported:

·         postgres does not seem to have support for something like ALTER 
EXTERNSION .... OWNER TO ...

·         pg_dump does not dump the owner.

Is this a bug? At least it is uncomfortable for me currently. Is any further 
support to change, export or otherwise handle extension owners planned?


Tested on a fresh postgres:14 docker container.


Regards,
Franz-Josef Färber

Reply via email to