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
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 |