On Thursday 13 February 2003 06:08, Tom Lane wrote:
Andreas Schmitz [EMAIL PROTECTED] writes:
I am still working on the newspaper archive project. I started indexing
the articles with tsearch. Along the long text parts I get a ERROR:
deadlock detected when I try to build the index update
Hello Tom,
after running 2 at jobs at night (cluster on txtidx indexes and vacuum full) I
tried again this morning 'cause the same job on a similar table structure
went fine.
newsdb2=# update dpa_text set titleidx=txt2txtidx(volltext);
ERROR: unnamed referential integrity violation - key
Hi *,
I am still working on the newspaper archive project. I started indexing the
articles with tsearch. Along the long text parts I get a ERROR: deadlock
detected when I try to build the index update dpa_text set
titleidx=txt2txtidx(volltext);. The table has a count of 356437 datarows. I