From: Tom Lane <tgl@sss.pgh.pa.us>
To: herve@duchesne.me
Cc: pgsql-docs@postgresql.org
Subject: Re: can't reproduce example
Date: Fri, 22 Sep 2017 11:47:19 -0400
Message-ID: <2754.1506095239@sss.pgh.pa.us> (raw)
In-Reply-To: <20170922150333.1448.70668@wrigleys.postgresql.org>
References: <20170922150333.1448.70668@wrigleys.postgresql.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
herve@duchesne.me writes:
> I tried to reproduce the example :
> CREATE EXTENSION btree_gist;
> CREATE TABLE room_reservation (
> room text,
> during tsrange,
> EXCLUDE USING GIST (room WITH =, during WITH &&)
> );
> but I got this error :
> ERROR: data type text has no default operator class for access method
> "gist"
It works for me. You sure you installed the extension successfully?
regards, tom lane
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, herve@duchesne.me
Subject: Re: can't reproduce example
In-Reply-To: <2754.1506095239@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox