Re: [GENERAL] GiST index question

[Eric Fleming]

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

[GENERAL] GiST index question

[Eric Fleming]

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.
—
Eric Fleming