"Stan S" <ssantiago@adinfocenter.com> writes:
> shard_1=# CREATE TABLE users (nickname CITEXT PRIMARY KEY,pass TEXT NOT
> NULL);
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey"
> for table "users"
> shard_1=# INSERT INTO users VALUES ( 'larry', 'aaa' );
> INSERT 0 1
> shard_1=# INSERT INTO users VALUES ( 'Tom', 'bbb' );
> ERROR: could not determine which collation to use for string comparison
> HINT: Use the COLLATE clause to set the collation explicitly.
Hmm, I can't replicate this here ...
> shard_1=# CREATE TABLE users (nickname CITEXT COLLATE "C" PRIMARY KEY,pass
TEXT NOT NULL);
> ERROR: collations are not supported by type citext
This suggests strongly that you're using a 9.0-or-earlier citext
installation that you've not upgraded to 9.1. If that's the right
guess, you need to do CREATE EXTENSION citext FROM unpackaged
to fix it.
regards, tom lane
