pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: herve@duchesne.me
To: pgsql-docs@postgresql.org
Subject: can't reproduce example
Date: Fri, 22 Sep 2017 15:03:33 +0000
Message-ID: <20170922150333.1448.70668@wrigleys.postgresql.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.5/static/rangetypes.html
Description:

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;
HINT:  You must specify an operator class for the index or define a default
operator class for the data type.

That means by default nobody is able to reproduce your example... Howto use
gist with text or varchar?

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


view thread (3+ messages)  latest in thread

Message-ID: <20170922150333.1448.70668@wrigleys.postgresql.org>
Permalink:  ../20170922150333.1448.70668@wrigleys.postgresql.org/
Also on:    postgresql.org/message-id/20170922150333.1448.70668@wrigleys.postgresql.org

 · 

reply
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: herve@duchesne.me
  Subject: Re: can't reproduce example
  In-Reply-To: <20170922150333.1448.70668@wrigleys.postgresql.org>

* 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