query = createPQExpBuffer();

/*

* Messy query to collect the dependency data we need. Note that we

* ignore the sub-object column, so that dependencies of or on a column

* look the same as dependencies of or on a whole table.

*

* PIN dependencies aren't interesting, and EXTENSION dependencies were

* already processed by getExtensionMembership.

*/

appendPQExpBufferStr(query, "SELECT "

"classid, objid, refclassid, refobjid, deptype "

"FROM pg_depend "

"WHERE deptype != 'p' AND deptype != 'e' "

"ORDER BY 1,2");

"WHERE deptype != 'p' AND deptype != 'e'\n");

/*

* Since we don't treat pg_amop entries as separate DumpableObjects, we

* have to translate their dependencies into dependencies of their parent

* opfamily. Ignore internal dependencies though, as those will point to

* their parent opclass, which we needn't consider here (and if we did,

* it'd just result in circular dependencies). Also, "loose" opfamily

* entries will have dependencies on their parent opfamily, which we

* should drop since they'd likewise become useless self-dependencies.

* (But be sure to keep deps on *other* opfamilies; see amopsortfamily.)

*/

appendPQExpBufferStr(query, "UNION ALL\n"

"SELECT 'pg_opfamily'::regclass AS classid, amopfamily AS objid, refclassid, refobjid, deptype "

"FROM pg_depend d, pg_amop o "

"WHERE deptype NOT IN ('p', 'e', 'i') AND "

"classid = 'pg_amop'::regclass AND objid = o.oid "

"AND NOT (refclassid = 'pg_opfamily'::regclass AND amopfamily = refobjid)\n");

/* Likewise for pg_amproc entries */

appendPQExpBufferStr(query, "UNION ALL\n"

"SELECT 'pg_opfamily'::regclass AS classid, amprocfamily AS objid, refclassid, refobjid, deptype "

"FROM pg_depend d, pg_amproc p "

"WHERE deptype NOT IN ('p', 'e', 'i') AND "

"classid = 'pg_amproc'::regclass AND objid = p.oid "

"AND NOT (refclassid = 'pg_opfamily'::regclass AND amprocfamily = refobjid)\n");

/* Sort the output for efficiency below */

appendPQExpBufferStr(query, "ORDER BY 1,2");

res = ExecuteSqlQuery(fout, query->data, PGRES_TUPLES_OK);