Ken Tanzer <ken.tanzer@xxxxxxxxx> writes: > I'm not sure what you mean or are suggesting by that. Is there something > I'm supposed to do to set the search path? Is that a known bug in > pg_dump? Something else? As mentioned, there is only one schema.... There was a security change to pg_dump a few years ago to make it put "set search_path = pg_catalog" into the dump script. This basically means that any user-defined function in indexes, check constraints, etc is on its own to be sure that it schema-qualifies non-system names, or has a "SET search_path" clause to do that for it. While that's annoying, it's also good practice. Functions that could be invoked in these contexts really ought not assume what search path they are called with. I do not think any of the other details you mentioned, such as use of --role, have any impact on this. regards, tom lane
