Tom Lane <t...@sss.pgh.pa.us> writes: > Dimitri Fontaine <dimi...@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 /* * If the referenced object is pinned by the system, there's no real * need to record dependencies on it. This saves lots of space in * pg_depend, so it's worth the time taken to check. */ Certainly, pg_catalog is pinned. select * from pg_depend where refobjid = (select oid from pg_namespace where nspname = 'pg_catalog') and refclassid = 'pg_namespace'::regclass; classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype ---------+-------+----------+------------+----------+-------------+--------- 0 | 0 | 0 | 2615 | 11 | 0 | p (1 row) Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers