On Tue, Sep 3, 2013 at 1:41 PM, Martin Renters <[email protected]> wrote:
> 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? > I would also like to see btree_gist support uuid's. I found a related thread from two years ago: http://postgresql.1045698.n5.nabble.com/UUID-datatype-GiST-index-support-td4722960.html
