Skip site navigation (1) Skip section navigation (2)

Re: Status of issue 4593

From: "Lee McKeeman" <lmckeeman(at)opushealthcare(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Status of issue 4593
Date: 2009-01-05 14:47:35
Message-ID: CB20429AE660CB43A946BF9D61C9A2B60D585D@ohsmail.opushealthcare.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
I got a "stalled post" message because at the time of filing I was not
on this list. I don't know when moderators would look at it, and if
perhaps they deemed that it should not be posted, so it was discarded
without me being notified. I have the text that was generated by the web
form, and can send it again now that I am on the list, but I don't want
to do so if that's bad form.

To add a little detail, this wasn't that I believed a sort wasn't
correct alphabetically, lexicographically, numerically, etc., but rather
when the sort was being performed.

-Lee

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us] 
Sent: Monday, January 05, 2009 8:39 AM
To: Lee McKeeman
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] Status of issue 4593 

"Lee McKeeman" <lmckeeman(at)opushealthcare(dot)com> writes:
> This may not be the appropriate place to check this, but when I filed
> the bug with the tracking number 4593, in relation to some sort order
> behavior which seemed erroneous to me.

That bug number never came by here --- might've gotten eaten by spam
filters?  Anyway, we've seen many many complaints about strange sort
ordering, and every one of them boiled down to Postgres doing what
the LC_COLLATE locale setting told it to.  Try "show lc_collate".
If it's not "C" you might wish to re-initdb in C locale.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2009-01-05 14:51:29
Subject: Re: incoherent view of serializable transactions
Previous:From: Tom LaneDate: 2009-01-05 14:39:15
Subject: Re: Status of issue 4593

pgsql-bugs by date

Next:From: Dave PageDate: 2009-01-05 14:56:30
Subject: Re: Status of issue 4593
Previous:From: Tom LaneDate: 2009-01-05 14:39:15
Subject: Re: Status of issue 4593

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group