Thread: Re: [HACKERS] Re: yet another problem in recent builds, GIST this time

Re: [HACKERS] Re: yet another problem in recent builds, GIST this time

From
Bruce Momjian
Date:
> "Gene Selkov, Jr." <selkovjr@mcs.anl.gov> wrote:
> >
> > I think I have another problem similar to what I just reported. This time it is in GiST. It does not
> > complain when it builds the index but any attempt to use the table with exesisting GiST indices causes
> > this error:
>
> You seem to be the only one who actually uses GiST <grin>

See manuals.  There is a web site for gist.

>
> During last 2-3 years I have posted the question about the usability
> of GiST indexes to various Postgres lists about 3 times with absolutely
> no reaction, so assumed that they didn't work at all ;(
>
> Could you point me to any information (FAQs, TFMs, ...) about their
> usage ?
>
> I have been under an impression that the easiest way of adding new
> indexing strategies (I personally need full-text) to postgres would
> be thru GiST, but as I have had no luck in getting them to waork as
> they were, I assumed that they were in fact unsupported remnants of
> a long-forgotten project.

Full text can now be done with the new /contrib/fulltextindex functions.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026


Re: [HACKERS] Re: yet another problem in recent builds, GIST this time

From
Hannu Krosing
Date:
Bruce Momjian wrote:
>
> > "Gene Selkov, Jr." <selkovjr@mcs.anl.gov> wrote:
> > >
> > > I think I have another problem similar to what I just reported. This time it is in GiST. It does not
> > > complain when it builds the index but any attempt to use the table with exesisting GiST indices causes
> > > this error:
> >
> > You seem to be the only one who actually uses GiST <grin>
>
> See manuals.  There is a web site for gist.

I know. It was put there after I pointed it out ;)

The website is about GiST, but has very little info about
actually using GiST with PostgreSQL

>
> Full text can now be done with the new /contrib/fulltextindex functions.
>

Does the code there work with 6.3.2 also, or have I to wait for 6.4 ?

-------------
Hannu

Re: [HACKERS] Re: yet another problem in recent builds, GIST this time

From
Bruce Momjian
Date:
> Bruce Momjian wrote:
> >
> > > "Gene Selkov, Jr." <selkovjr@mcs.anl.gov> wrote:
> > > >
> > > > I think I have another problem similar to what I just reported. This time it is in GiST. It does not
> > > > complain when it builds the index but any attempt to use the table with exesisting GiST indices causes
> > > > this error:
> > >
> > > You seem to be the only one who actually uses GiST <grin>
> >
> > See manuals.  There is a web site for gist.
>
> I know. It was put there after I pointed it out ;)
>
> The website is about GiST, but has very little info about
> actually using GiST with PostgreSQL
>
> >
> > Full text can now be done with the new /contrib/fulltextindex functions.
> >
>
> Does the code there work with 6.3.2 also, or have I to wait for 6.4 ?

I think it works for both.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026