"D.J. Kniep" <dick(dot)kniep(at)lindix(dot)nl> writes:
> After setting the search path the query
> Select * from vwexternetoegang
> produces the required results in the first installation, but in the new
> installation, it cannot find the view. However, if I do an explicit
> Set search_path to "testschema";
> it works as expected.
What does "show search_path" report in the failing and non-failing states?
Also try "select current_schemas(true)".
regards, tom lane