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
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 dpa_text set
> titleidx=txt2txtidx(volltext);".
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 inde
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: referential integrity violation - key referenced
