Re: ERROR: deadlock detected

Andreas Schmitz <a.schmitz@cityweb.de> 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);". The table has a count of 356437 datarows. I
> already increased the number of locks per transaction. Any ideas on that ?

This does not sound like an out-of-resources kind of problem.  Either
you did something wrong or you found a bug.  But it's impossible to
tell which.  Can you provide a SQL script that reproduces the behavior
you're seeing?

            regards, tom lane