Forum OpenACS Q&A: problems with islossy GiST indices in Postgres 7.2

Collapse
1: problems with islossy GiST indices in Postgres 7.2
Posted by Vadim Nasardinov on 05/22/02 12:23 AM

I am trying to get the OpenFTS package running in OpenACS 4.5b1 with Postgres 7.2 on Red Hat Linux 7.3. Ran into the following issue. 

 
openacs=# CREATE INDEX gist_key on txt  using gist ( fts_index gist__intbig_ops ) with (islossy);
ERROR:  parser: parse error at or near "with"
openacs=# CREATE INDEX gist_key on txt  using gist ( fts_index gist__intbig_ops );
CREATE

In other words, trying to mark the index "islossy" is causing a parse error. What am I missing?

Collapse
2: Response to problems with islossy GiST indices in Postgres 7.2 (response to 1)
Posted by Don Baccus on 05/22/02 02:58 AM
This is a question for the PG folks ... I doubt anyone here knows off the top of their heads.

If someone proves me wrong, great!

If not ... can you ask over there and report back?  The with clause has been taken out of the grammar (I checked the PG sources) but there's no comment explaining why.

It may be that it's no longer needed ... but I'd ask before assuming that.

Collapse
3: Response to problems with islossy GiST indices in Postgres 7.2 (response to 1)
Posted by Vadim Nasardinov on 05/22/02 03:18 AM
I thought Dan might know.
Collapse
4: Response to problems with islossy GiST indices in Postgres 7.2 (response to 1)
Posted by Dan Wickstrom on 05/22/02 04:09 AM
The changelog in intarray has the following comment:

  1. gist__int_ops now is without lossy