On Fri, Mar 03/22/13, 2013 at 10:14:45AM -0600, Denver Timothy wrote:
> In PostgreSQL 9.2.3 I am trying to create this simplified table:
> 
>     CREATE TABLE test (
>         user_id INTEGER,
>         startend TSTZRANGE,
>         EXCLUDE USING gist (user_id WITH =, startend WITH &&)
>     );
> 
> But I get this error:
> 
>     ERROR:  data type integer has no default operator class for access method 
> "gist"
>     HINT:  You must specify an operator class for the index or define a 
> default operator class for the data type.
> 
> I've spent quite a bit of time searching for hints on figuring out how to 
> make this work, or figuring out why it won't work. I've also been trying to 
> understand CREATE OPERATOR and CREATE OPERATOR CLASS, but those are over my 
> head for now. Could anyone point me in the right direction?

CREATE EXTENSION btree_gist;

-Ryan Kelly


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to