Re: Vacuuming unicode database

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Tambet Matiisen <t(dot)matiisen(at)aprote(dot)ee>, pgsql-general(at)postgresql(dot)org
Subject: Re: Vacuuming unicode database
Date: 2003-08-14 03:38:43
Message-ID: 20030814033843.GB13887@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 13, 2003 at 12:50:03PM -0400, Tom Lane wrote:
> Unfortunately, we don't have any way of dealing with different character
> sets or locales in different tables. (AFAICT this is not practical
> without implementing our own locale library, which would be an enormous
> task; someday we will solve this problem, but don't hold your breath.)
> So pg_shadow, pg_group, and pg_database are all risk spots.

All this stuffing around with multiple locales and collating stuff on the
fly. Surely we're not the only project to have to deal with this problem?
Someone must have come up witha set of routines to deal with this. If it
can be abstracted into a library to share around it could be made much
easier.

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato

In response to

Browse pgsql-general by date

  From Date Subject
Next Message expect 2003-08-14 03:39:41 Why the duplicate messages to pgsql-general?
Previous Message Stephan Szabo 2003-08-14 02:23:58 Re: drop/add fk in transaction