GiST index question

From: "Eric Fleming" <efleming(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: GiST index question
Date: 2014-09-03 23:35:50
Message-ID: 1409787350177.12697169@Nodemailer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Goess 2014-09-04 00:17:36 Re: free RAM not being used for page cache
Previous Message Adrian Klaver 2014-09-03 19:25:43 Re: Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.