Re: [BUGS] BUG #1858: setting search path in select doesn't (always) work

2005-09-03 Thread Dick Kniep
Hi list, I reported the bug because I was convinced it was something fishy, however, the bug I reported proved to be something completely else. I don't even know if it is a bug at all. If you do a set search_path; the path is set correctly according to the rules of autocommit and everything el

Re: [BUGS] BUG #1858: setting search path in select doesn't (always) work

2005-09-02 Thread Michael Fuhr
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

Re: [BUGS] BUG #1858: setting search path in select doesn't (always) work

2005-09-02 Thread Tom Lane
"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";

[BUGS] BUG #1858: setting search path in select doesn't (always) work

2005-09-02 Thread D.J. Kniep
The following bug has been logged online: Bug reference: 1858 Logged by: D.J. Kniep Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.8 Operating system: Linux (SuSE 9.3) /RedHat ES 4 Description:setting search path in select doesn't (always) work Details: we