Hi Eric, As Michael said, path data type does not support for gist operators. Anyway, you could redefine data type using 'ltree' instead of 'path'. Take a look on the following link:
http://www.postgresql.org/docs/9.1/static/ltree.html Try to understand if this could be fine for you. Cheers, Giuseppe. 2014-09-04 6:31 GMT+02:00 Michael Paquier <michael.paqu...@gmail.com>: > On Thu, Sep 4, 2014 at 8:35 AM, Eric Fleming <eflem...@gmail.com> wrote: > > I have a table that I have defined as: > > > > CREATE TABLE test ( > > "id" SERIAL PRIMARY KEY, > > "first_path" path NOT NULL, > > "second_path" path NOT NULL > > ); > > > > I am attempting to create a GiST index on the two "path" columns using: > > > > CREATE INDEX "idx_test_first_path" ON test USING gist(first_path); > > CREATE INDEX "idx_test_second_path" ON test USING gist(second_path); > > > > I am getting this error: > > > > Error : ERROR: data type path has no default operator class for access > > method "gist" > > > > Is it that I am not allowed to create an index on the path data type or > do I > > need to enable an extension for this to work? Thanks in advance for your > > help. > In-core contrib modules (and core) do not have yet support for gist > operator classes for the datatype path as far as I recall. > Regards, > -- > Michael > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it
