From: | "Andrew J(dot) Kopciuch" <akopciuch(at)olympusproject(dot)org> |
---|---|
To: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: tsearch2 and unexpected exists |
Date: | 2003-09-04 18:07:41 |
Message-ID: | 200309041207.41517.akopciuch@olympusproject.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> What I did was install tsearch2 using share/contrib/tsearch2.sql, which
> placed everything into public schema. Having created the tsvector column in
> a table and populated it I tried running a pretty simple function that
> queried that table (joined with another) using that tsvector column in the
> where clause. This gave the unexpected exits of the backend (only the one
> for that connection not all). The error was something like invalid
> MemoryContext allocation 0. Other attempts gave a large number instead of
> 0. However, the odd thing is that the query from the function that was
> using tsearch2 worked fine when I cut it from the log and pasted it into
> psql directly.
>
> The function is in plpgsql, this is the stable tarball of tsearch v2 for
> 7.3.4 and obviously the server is 7.3.4. All running on Debian linux
> (woody).
>
Can you post some table definitions, and the function you used? It would be
nice to see exactly what you are attempting.
Andy
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-09-04 18:18:20 | Re: Crosstab function Problem |
Previous Message | Ron | 2003-09-04 18:04:44 | Re: is it possible to do this? have a subselect that |