From: Herve Duchesne <hduchesn@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: herve@duchesne.me
Cc: pgsql-docs@postgresql.org
Subject: Re: can't reproduce example
Date: Mon, 25 Sep 2017 11:38:33 +0200
Message-ID: <c358e481-2d7b-18c4-a489-73710d1d9cdf@gmail.com> (raw)
In-Reply-To: <2754.1506095239@sss.pgh.pa.us>
References: <20170922150333.1448.70668@wrigleys.postgresql.org>
<2754.1506095239@sss.pgh.pa.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
You are right,
CREATE EXTENSION btree_gist;
the command failed because I was not superuser. I did it as postgres
user and It works now.
Thanks.
Le 22/09/2017 à 17:47, Tom Lane a écrit :
> 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: hduchesn@gmail.com, tgl@sss.pgh.pa.us, herve@duchesne.me
Subject: Re: can't reproduce example
In-Reply-To: <c358e481-2d7b-18c4-a489-73710d1d9cdf@gmail.com>
* 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