[GENERAL] where is the locale set for each server instance?

2005-03-13 Thread Palle Girgensohn
Hi! I'm pluggin ICU into PostgreSQL for unicode collation, since FreeBSD has no support for unicode collation. It works fine, but I cannot find out where to set the default locale for each backend instance. I want to use the LC_COLLATE used in initdb, now I've just hard wired it for my own

Re: [GENERAL] where is the locale set for each server instance?

2005-03-13 Thread Tom Lane
Palle Girgensohn [EMAIL PROTECTED] writes: So, I'm trying to find out where LC_COLLATE is overridden. Any tips? access/transam/xlog.c (which is the only file that touches pg_control, I believe). regards, tom lane ---(end of

Re: [GENERAL] where is the locale set for each server instance?

2005-03-13 Thread Palle Girgensohn
--On söndag, mars 13, 2005 17.01.31 -0500 Tom Lane [EMAIL PROTECTED] wrote: Palle Girgensohn [EMAIL PROTECTED] writes: So, I'm trying to find out where LC_COLLATE is overridden. Any tips? access/transam/xlog.c (which is the only file that touches pg_control, I believe). OK, seems my problem is

Re: [GENERAL] where is the locale set for each server instance?

2005-03-13 Thread Tom Lane
Palle Girgensohn [EMAIL PROTECTED] writes: OK, seems my problem is with ICU. The xlog.c:ReadConfigFile() is not run for each backend, it seems, I assume it is forked after that. No, it is run once in the postmaster, as indeed the comments in it say. Seems ICU cannot remember a

Re: [GENERAL] where is the locale set for each server instance?

2005-03-13 Thread Palle Girgensohn
--On söndag, mars 13, 2005 18.37.24 -0500 Tom Lane [EMAIL PROTECTED] wrote: Palle Girgensohn [EMAIL PROTECTED] writes: OK, seems my problem is with ICU. The xlog.c:ReadConfigFile() is not run for each backend, it seems, I assume it is forked after that. No, it is run once in the postmaster, as