Postgresql 9.1: ERROR: type "citext" does not exist
- by gotuskar
I am trying to execute following query through PgAdmin utility.
CREATE TABLE svcr."EventLogs" ("eventId" BIGINT NOT NULL,
"eventTime" TIMESTAMP WITH TIME ZONE NOT NULL, "userid" CITEXT,
"realmid" CITEXT NOT NULL, "onUserid" CITEXT, "description" TEXT,
CONSTRAINT eventlogs_pkey PRIMARY KEY ("eventId"));
And I get following error -
ERROR: type "citext" does not exist
SQL state: 42704
Character: 120
However, following query runs fine -
CREATE TABLE svcr."CategoryMap" ("category" INT NOT NULL,
"userData" INT NOT NULL);
What is wrong with the first query?