| From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Me Chai Swee <mech(at)me(dot)com> |
| Subject: | tsvector work with citext |
| Date: | 2015-09-17 04:00:55 |
| Message-ID: | EA8346F9-8F64-4837-ABE1-B383AF36E0DC@kineticode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hey Hackers,
Is there a way to get tsvector_update_trigger() to work with citext columns? The attached case throws an error:
ERROR: column "title" is not of a character type
Is the fact that citext is a (non-preferred) member of the string category not sufficient for this to work? If not, are there any workarounds?
Thanks,
David
| Attachment | Content-Type | Size |
|---|---|---|
| try.sql | application/sql | 399 bytes |
| unknown_filename | text/plain | 2 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2015-09-17 04:32:17 | Obsolete use of volatile in walsender.c, walreceiver.c, walreceiverfuncs.c? |
| Previous Message | Fujii Masao | 2015-09-17 03:25:36 | Re: pg_resetxlog sentences |