On Fri, Sep 02, 2005 at 10:58:12AM -0400, Tom Lane wrote: > "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)".
This thread came up in pgsql-general yesterday; Dick says the real problem was something else. http://archives.postgresql.org/pgsql-general/2005-09/msg00074.php -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
