Re: [WIP] patch - Collation at database level

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Zdenek Kotala <Zdenek.Kotala@Sun.COM>
Cc: Martijn van Oosterhout <kleptog@svana.org>, Gregory Stark <stark@enterprisedb.com>, Alvaro Herrera <alvherre@commandprompt.com>, Radek Strnad <radek.strnad@gmail.com>, pgsql-hackers@postgresql.org
Date: 2008-07-08T13:49:19Z
Lists: pgsql-hackers
Zdenek Kotala <Zdenek.Kotala@Sun.COM> writes:
> Martijn van Oosterhout napsal(a):
>> Not necessarily. pg_class is not shared yet without it you can't even
>> find pg_database. Same deal with pg_type. All it means is that
>> pg_collation in template1 must contain all the collations used in
>> template1, which shouldn't be hard to arrange.

> I think, Collation situation is different,

All the argument here is based on the premise that we should have
database-level collation specifications, which AFAICS is not required
nor suggested by the SQL spec.  I wonder why we are allowing a
nonstandard half-measure to drive our thinking, rather than solving the
real problem which is column-level collations.

			regards, tom lane