search

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
https://www.yugabyte.com
Other
8.98k stars 1.07k forks source link

[YSQL] Index not supported on citext column #9698

Open timothyvanderaerden opened 3 years ago

timothyvanderaerden commented 3 years ago

Jira Link: DB-2117 When trying to create an index on a column with type citext I get the following error:

SQL Error [0A000]: ERROR: INDEX on column of type 'user_defined_type' not yet supported

I tested with the following SQL:

CREATE TABLE public.test (
    email citext NULL
);
CREATE INDEX test_email_idx ON public.test (email);
ddorian commented 3 years ago

Hi @timothyvanderaerden

Indexes on citext aren't yet available. As a workaround you can use LOWER() like it's explained in PostgreSQL docs.