"D.J. Kniep" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
