> 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