uuids with btree_gist

From: Martin Renters <martin(at)datafax(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: uuids with btree_gist
Date: 2013-09-03 20:41:53
Message-ID: C59F2565-4753-4C83-BDCD-A0F9430B1638@datafax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to use timestamp ranges to keep track of the values particular items had over time, but I'm unable to create a table as follows:

test=# create extension btree_gist;
CREATE EXTENSION
test=# create table v(item uuid, lifetime tstzrange, value text,
test(# exclude using gist (item with =, lifetime with &&));
ERROR: data type uuid has no default operator class for access method "gist"
HINT: You must specify an operator class for the index or define a default operator class for the data type.
test=#

It works fine if I make item a text field.

test=# create table v(item text, lifetime tstzrange, value text,
test(# exclude using gist (item with =, lifetime with &&));
CREATE TABLE
test=#

Is there any reason that the required uuid access method isn't implemented? How hard is it to implement this?

Thanks,

Martin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2013-09-03 21:07:26 Re: store multiple rows with the SELECT INTO statement
Previous Message Adrian Klaver 2013-09-03 20:31:49 Re: store multiple rows with the SELECT INTO statement