On Tue, Mar 3, 2015 at 11:15 AM, Kai Groner <k...@gronr.com> wrote:
> I found it necessary to add the gist_text_ops opclass for the inequality:
>
> CREATE TABLE person (
> id INTEGER PRIMARY KEY,
> "user" TEXT,
> email TEXT NOT NULL,
> EXCLUDE USING gist (email WITH =, "user" gist_text_ops WITH <>)
> WHERE ("user" IS NOT NULL));
>
> Is that expected?
>Never mind. I was creating the extension on the wrong database and misunderstood the error. Kai
