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 #1859: 3-octet private use UTF8 chars reported as identical

2005-09-02 Thread Tom Lane
"Nathan Culwell-Kanarek" <[EMAIL PROTECTED]> writes: > Description:3-octet private use UTF8 chars reported as identical > We've run into a problem, which is that > the PostgreSQL backend is interpreting 4 of the private use characters as > being equivalent. Your beef is actually with strc

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";

Re: [BUGS] Sorting Problem in UNICODE/german

2005-09-02 Thread Tom Lane
Andreas Seltenreich <[EMAIL PROTECTED]> writes: >> Klaus Ita schrob: >>> this is also wrong (There should be 'Unter' and then 'U:berflieger' >>> [Überflieger]). so is this a libc bug? > I think I got your point now. Libc appears to be using iso-14651 > sorting for all "de" locales. I'm afraid you

[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

[BUGS] Compile with Solaris 10 AMD 64bit Sun CC

2005-09-02 Thread Martijn de Munnik
Hi I'm trying to compile PostgreSQL 8.0.3 on a Sun Solaris 10 box, dual opteron and using the sun studio cc compiler. I get the following error; cc -Xa -fast -xarch=amd64 -I../../../../src/include -fast - xarch=amd64 -c -o clog.o clog.c cc -Xa -fast -xarch=amd64 -I../../../../src/include -

[BUGS] BUG #1859: 3-octet private use UTF8 chars reported as identical

2005-09-02 Thread Nathan Culwell-Kanarek
The following bug has been logged online: Bug reference: 1859 Logged by: Nathan Culwell-Kanarek Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Fedora Core Linux 4 Description:3-octet private use UTF8 chars reported as identical Details:

Re: [BUGS] Sorting Problem in UNICODE/german

2005-09-02 Thread Andreas Seltenreich
Sorry, I just reread your mail: Your MUA is declaring it with > Content-Type: text/plain; charset=unknown-8bit This makes it even harder to discuss problems with Umlauts :-). Andreas Seltenreich schrob: > Klaus Ita schrob: > >> another "funny" thing is: >> >> [EMAIL PROTECTED]:~/.mutt$ [EMAIL

Re: [BUGS] Sorting Problem in UNICODE/german

2005-09-02 Thread Andreas Seltenreich
Klaus Ita schrob: > On Thu, Sep 01, 2005 at 09:30:15AM -0400, Tom Lane wrote: >> Klaus Ita <[EMAIL PROTECTED]> writes: >> > I have tried starting postgres with [EMAIL PROTECTED] >> > locale but that did not help. >> > > i did read the docs and am still not quite happy with my sorting results. > o