Francisco Reyes <lists@xxxxxxxxxxxxxxxx> writes: > Tom Lane writes: >> SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' ORDER BY 1,2 >> so apparently something is fishy about the dependency data. Can you >> execute this query by hand and get results? > Nothing happens when I try to run the query. So pg_dump seems off the hook. Can you run the query, attach to the backend with gdb, and see what it's doing? regards, tom lane