| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | chu_z(at)hotmail(dot)com |
| Subject: | Correction |
| Date: | 2022-07-22 00:24:03 |
| Message-ID: | 165844944334.271448.18067658391804504480@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/citext.html
Description:
"If you declare a column as UNIQUE or PRIMARY KEY, the implicitly generated
index is case-sensitive. So it's useless for case-insensitive searches, and
it won't enforce uniqueness case-insensitively."
I think the statement above is not correct. I tried creating a PK or unique
key index on a CITEXT column. It checks uniqueness in case-insensitivity.
Here is the error I got when I tried to add a duplicated value 'Des'.
DETAIL: Key (des)=(Des) already exists.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2022-07-22 02:02:18 | Re: documentation on HOT |
| Previous Message | Bruce Momjian | 2022-07-21 18:55:48 | Re: "Restore" vs. "Reload" |