Στις Wednesday 03 February 2010 21:16:36 ο/η Peter Eisentraut έγραψε:
On ons, 2010-02-03 at 17:05 +0200, Achilleas Mantzios wrote:
Στις Wednesday 03 February 2010 16:53:20 ο/η Peter Eisentraut έγραψε:
On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote:
It seems that libc's
Στις Tuesday 02 February 2010 17:37:05 ο/η Tom Lane έγραψε:
Achilleas Mantzios ach...@matrix.gatewaynet.com writes:
What is the shortest way to change the default locale on a production
installation running PostgreSQL-8.3.9?
Is there anything less painful than dump, initdb,restore?
No
On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote:
It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD
are two different stories, hence the seen results.
The UTF-8 locales on FreeBSD and Mac OS X are pretty much broken.
This is becoming a FAQ ...
--
Sent via
Στις Wednesday 03 February 2010 16:53:20 ο/η Peter Eisentraut έγραψε:
On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote:
It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD
are two different stories, hence the seen results.
The UTF-8 locales on FreeBSD and Mac OS
On ons, 2010-02-03 at 17:05 +0200, Achilleas Mantzios wrote:
Στις Wednesday 03 February 2010 16:53:20 ο/η Peter Eisentraut έγραψε:
On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote:
It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD
are two different stories,
Hi, i have the following problem, text ordering seems to behave incosistently
across various lc_collate values, OS'es, PostgreSQL versions.
Some behaviour might be expected, some not, thats why i am asking to see where
i stand with this.
Test Data
postg...@dynacom=# SELECT * from
It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD are two
different stories, hence the seen results.
(Switching LC_COLLATE between en_US.UTF-8 and POSIX, in FreeBSD it does not
have any impact on orderring while in Linux does)
I think i have resolved the issue, so the solution
Achilleas Mantzios ach...@matrix.gatewaynet.com writes:
What is the shortest way to change the default locale on a production
installation running PostgreSQL-8.3.9?
Is there anything less painful than dump, initdb,restore?
No :-(
regards, tom lane
--
Sent via