Dimitri Fontaine <dimitri@2ndQuadrant.fr> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> Dimitri Fontaine <dimitri@2ndQuadrant.fr> writes:
>>> The missing entry in pg_depend is the reason why the extension is not
>>> part of the dump. We could fix that using a LEFT JOIN here and COALESCE
>>> to force the namespace as pg_catalog. Is that not a kludge?
>> Yes, it is. Why is the pg_depend entry missing?
> See src/backend/catalog/pg_depend.c
> Certainly, pg_catalog is pinned.
OK, so I guess I'm missing why the extension code is looking for stuff
dependent on the pg_catalog schema. That schema certainly doesn't
belong to any extension.
In any case, your proposed hack above is effectively assuming that
there's only one pinned schema, which is untrue now and is likely to
become even less true in the future. So I don't think we can go that way.
regards, tom lane