Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA82267 for ; Wed, 9 Jun 1999 20:56:37 -0400 (EDT) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id UAA14722; Wed, 9 Jun 1999 20:54:38 -0400 (EDT) From: Bruce Momjian Message-Id: <199906100054.UAA14722@candle.pha.pa.us> Subject: Re: [HACKERS] Postgres 6.5 beta2 and beta3 problem In-Reply-To: <375EBAA0.D5DE4B2E@trust.ee> from Hannu Krosing at "Jun 9, 1999 10:04:00 pm" To: Hannu Krosing Date: Wed, 9 Jun 1999 20:54:38 -0400 (EDT) CC: Oleg Bartunov , ZEUGSWETTER Andreas IZ5 , "'hackers@postgresql.org'" X-Mailer: ELM [version 2.4ME+ PL56 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > Oleg Bartunov wrote: > > > > > > Thanks for explanations. It would be great if I could specify for specific > > columns if it needs locale. For now I have to pay decreasing in speed > > just to enable locale for the only column of one database !!! > > I always dream to be able to specify on fly 'SET LOCALE to ON|OFF' > > It's a bit separate problem, but probably more easy to implement. > > Actually the locale should be part of field definition (like length and > precision currently are) with default of ascii. > > And also it may be probably safest to maintain our own locale defs (as > Oracle > currently does)so that things don't break if somebody changes the system > ones. Added to TODO: * Allow LOCALE on a per-column basis, default to ASCII -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026