Re: can't reproduce example

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: herve(at)duchesne(dot)me
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: can't reproduce example
Date: 2017-09-22 15:47:19
Message-ID: 2754.1506095239@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

herve(at)duchesne(dot)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 &amp;&amp;)
> );

> but I got this error :
> ERROR: data type text has no default operator class for access method
> &quot;gist&quot;

It works for me. You sure you installed the extension successfully?

regards, tom lane

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message zszmigiero 2017-09-24 11:01:57 RECURSIVE update
Previous Message herve 2017-09-22 15:03:33 can't reproduce example