Postgresql 9.1: ERROR: type "citext" does not exist
Posted
by
gotuskar
on Stack Overflow
See other posts from Stack Overflow
or by gotuskar
Published on 2012-10-28T22:50:40Z
Indexed on
2012/10/28
23:00 UTC
Read the original article
Hit count: 202
Filed under:
database
|postgresql-9.1
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?
© Stack Overflow or respective owner
