Re: [HACKERS] Locale, Collation, ICU patch

2008-04-04 Thread Martijn van Oosterhout
On Thu, Apr 03, 2008 at 06:54:50PM +0100, Gregory Stark wrote: > The big gotcha is what collation to use when comparing with data in the system > tables, especially the shared system tables. I think we do need to define a > database-wide encoding and collation to use for system tables. (Unless we c

Re: [HACKERS] Locale, Collation, ICU patch

2008-04-03 Thread Andrew Dunstan
Tom Lane wrote: The other issue that'd have to be resolved is the problem of system log output. I think we'd wish that log messages are written in a uniform encoding (CSV output in particular is going to have a hard time otherwise) but what do you do when you need to report something that incl

Re: [HACKERS] Locale, Collation, ICU patch

2008-04-03 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > The big gotcha is what collation to use when comparing with data in the system > tables, especially the shared system tables. I think we do need to define a > database-wide encoding and collation to use for system tables. You mean cluster-wide? If we ca

[HACKERS] Locale, Collation, ICU patch

2008-04-03 Thread Gregory Stark
Regarding the ICU patch in the commitfest here's my plan. IMHO the idea of making ICU a hard dependency which Postgres will have to use forevermore on all systems is a non-starter. I'm not entirely against having ICU as a supported collation system which packagers on systems where the system loc