Primary key gist index? - Mailing list pgsql-general

From Jeremy Finzel
Subject Primary key gist index?
Date
Msg-id CAMa1XUiQDM2n5EHPir_ECoTjdA=kEDu1u_p=zMUxzdkkJpgmhw@mail.gmail.com
Whole thread Raw
Responses Re: Primary key gist index?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Primary key gist index?  (Paul Jungwirth <pj@illuminatedcomputing.com>)
List pgsql-general
Hello!  From all that I can tell, it is not possible using a btree_gist index as a primary key.  If so, why not?  I have a table with this gist index which truly ought to be its primary key.  as_of_date is of range date type:

EXCLUDE USING gist (id WITH =, as_of_date WITH &&)

Any direction here would be much appreciated.

Right now, I am forced to create a redundant btree index UNIQUE, btree (id, lower(as_of_date)) in order to have a primary key on the table.

Thanks!
Jeremy

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: JDBC connectivity issue
Next
From: Adrian Klaver
Date:
Subject: Re: Primary key gist index?