Re: collations in shared catalogs? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: collations in shared catalogs?
Date
Msg-id 20150430150101.GB1894@momjian.us
Whole thread Raw
In response to Re: collations in shared catalogs?  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: collations in shared catalogs?
List pgsql-hackers
On Wed, Feb 25, 2015 at 10:19:45PM +0100, Andres Freund wrote:
> On 2015-02-25 15:59:55 -0500, Tom Lane wrote:
> > Andres Freund <andres@2ndquadrant.com> writes:
> > > On 2015-02-25 12:08:32 -0500, Tom Lane wrote:
> > >> The most obvious fix is to change "provider" to a NAME column.
> > 
> > > Yea. I'm not sure why that wasn't done initially. I can't really see the
> > > length be an issue. How about we add an error check enforcing ascii,
> > > that'll work in the back branches?
> > 
> > Nope, that won't help much at all.  C vs en_US for instance is different
> > sort orders even with all-ASCII data.
> 
> Ick, yes. The restriction to a charset that's encodable in all server
> encodings should be there additionally, but it's not sufficient :(
> 
> > Basically you're screwed if you've got different collations in different
> > databases and you put anything into pg_shseclabel ...
> 
> Hrmpf.

Where are we on this?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Turning recovery.conf into GUCs
Next
From: Tom Lane
Date:
Subject: Re: Precedence of NOT LIKE, NOT BETWEEN, etc