Horton

Re: [WIP] patch - Collation at database level

Zdenek Kotala <zdenek.kotala@sun.com>

View thread View on postgr.es
From: Zdenek Kotala <Zdenek.Kotala@Sun.COM>
To:
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Gregory Stark <stark@enterprisedb.com>, Alvaro Herrera <alvherre@commandprompt.com>, Radek Strnad <radek.strnad@gmail.com>, pgsql-hackers@postgresql.org
Date: 2008-07-08T09:27:35Z
Lists: pgsql-hackers 
Zdenek Kotala napsal(a):

> 
> I though more about it and I discussed it with Radek yesterday. The 
> problem is that collation must be created before user want to use CREATE 
> DATABASE ... COLLATE ... command. It inclines to have have pg_collation 
> as a global catalog, but ANSI specifies to use schema name in collation 
> specification and schemes are database specific ... It means that 
> pg_collation have to be non-shared catalog and new database only 
> inherits collation from template db. And CREATE DATABASE have to check 
> list of collation in template database :(.

thinking more ...
It must be shared catalog because pg_database will depend on it.

	Zdenek


-- 
Zdenek Kotala              Sun Microsystems
Prague, Czech Republic     http://sun.com/postgresql