Am Monday, 28. July 2008 schrieb Tom Lane:
> But to define such a domain, you'd have to commit to a case-insensitive
> version of a specific collation, no? citext currently means "case
> insensitive version of whatever the database's default collation is".
So in the future, someone using citext with lc_collate = en_US attempting to
upgrade would then define
CREATE DOMAIN citext AS text COLLATION "en_US(at)ci"
And yes, you would potentially have different definitions of this citext
domain in different database clusters, depending on what configuration you
are upgrading from, but I don't see that as a problem. It is the natural
thing to do.
In response to
pgsql-hackers by date
|Next:||From: Peter Eisentraut||Date: 2008-07-29 07:58:33|
|Subject: Re: Python 2.5 vs the buildfarm|
|Previous:||From: Jan Urbański||Date: 2008-07-29 07:27:11|
|Subject: Re: gsoc, oprrest function for text search|