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
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. |