Re: [BUGS] BUG #6259: Collation Error with Citext fields

2011-10-17 Thread Tom Lane
"Stan S" 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 u

[BUGS] BUG #6259: Collation Error with Citext fields

2011-10-17 Thread Stan S
The following bug has been logged online: Bug reference: 6259 Logged by: Stan S Email address: ssanti...@adinfocenter.com PostgreSQL version: 9.1.1 Operating system: CentOS release 5.4 (Final) Description:Collation Error with Citext fields Details: Greetings, I'm en