From: | Giuseppe Broccolo <giuseppe(dot)broccolo(at)2ndquadrant(dot)it> |
---|---|
To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
Cc: | Eric Fleming <efleming(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: GiST index question |
Date: | 2014-09-04 07:42:15 |
Message-ID: | CAFzmHiXWGAN5Be9vrYTEsg6DPF92+4dLxFNur=5j+YYyceCWEA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)paquier(at)gmail(dot)com>:
> On Thu, Sep 4, 2014 at 8:35 AM, Eric Fleming <efleming(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Giuseppe Broccolo - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
giuseppe(dot)broccolo(at)2ndQuadrant(dot)it | www.2ndQuadrant.it
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2014-09-04 08:38:45 | Re: copymanager question |
Previous Message | Sameer Thakur | 2014-09-04 07:01:52 | Merge requirements between offline clients and central database |