Thank you both, I will look into alternative data types. I don’t think ltree will work for my purposes but I am going to try out some others that might; like cube. — Eric Fleming
On Thu, Sep 4, 2014 at 3:42 AM, Giuseppe Broccolo <giuseppe.brocc...@2ndquadrant.it> wrote: > 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
