On Tue, Mar 3, 2015 at 11:15 AM, Kai Groner <kai@xxxxxxxxx> 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
