Issue with pg_dump Including Ownership Metadata for pg_trgm Extension in PostgreSQL 17

Dear PostgreSQL Bug Team,

I am encountering an issue in PostgreSQL 17 with pg_dump when working with
the pg_trgm extension. Specifically, when using pg_dump to back up a
database containing the pg_trgm extension, ownership metadata for extension
member objects is included in the dump, even when the --no-owner flag is
used.

This leads to conflicts during restores in environments where ownership
constraints differ, disrupting migrations and automated workflows. It is
particularly problematic when ownership has been changed after the
extension was initially created (via CREATE EXTENSION).

Steps to reproduce:

1.

Install the pg_trgm extension.
2.

Change the ownership of the objects created by the extension.
3.

Run pg_dump with the --no-owner flag.
4.

Restore the dump in a different environment where ownership constraints
differ.

Expected behavior: Ownership metadata should not be included in the dump
when the --no-owner flag is specified, especially for objects created by
the pg_trgm extension.

Actual behavior: Ownership metadata is still included in the dump, causing
issues when restoring to different environments.

This issue has been persistent across multiple versions of PostgreSQL and
significantly impacts automated deployment and migration workflows.

I would appreciate any assistance in resolving this issue, or any guidance
on how to work around this limitation in the meantime.

Thank you for your attention to this matter.
Best regards,
Akash Bhujbal