Re: [BUGS] [HACKERS] Mac OS X, PostgreSQL, PL/Tcl

2004-02-21 Thread Scott Goodwin
Found the problem. If I have a very long environment variable exported and I start PG, PG crashes when I try to load PG/Tcl. In my case I use color ls and I have a very long LS_COLORS environment variable set. I have duplicated the problem by renaming my .bashrc and logging back in. With thi

Re: [BUGS] BUG #1082: Order by doesn't sort correctly.

2004-02-21 Thread Tom Lane
Richard Neill <[EMAIL PROTECTED]> writes: > This ordering is perverse! No kidding. > No matter what the priority is of the > different characters, I cannot understand how the above can arise. You are assuming that it's a byte-at-a-time process. It's not. I believe the first pass considers onl

Re: [BUGS] BUG #1082: Order by doesn't sort correctly.

2004-02-21 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > Description:Order by doesn't sort correctly. It almost certainly is the correct sort order according to the locale you're using. Use pg_controldata to check the database locale. You'll probably want to re-initdb in C locale. Most non-

[BUGS] BUG #1082: Order by doesn't sort correctly.

2004-02-21 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1082 Logged by: Richard Neill Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.4 Operating system: Linux Description:Order by doesn't sort correctly. Details: ORDER BY sorts the following in this