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 :
he...@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
