Re: ERROR: deadlock detected ->referential integrity violation - Mailing list pgsql-admin

From Andreas Schmitz
Subject Re: ERROR: deadlock detected ->referential integrity violation
Date
Msg-id 200302131137.29569.a.schmitz@cityweb.de
Whole thread Raw
In response to Re: ERROR: deadlock detected  (Andreas Schmitz <a.schmitz@cityweb.de>)
List pgsql-admin
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 referenced from
dpa_text not found in dpa

any ideas ?

regards

-andreas

--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email a.schmitz@cityweb.de


pgsql-admin by date:

Previous
From: Andreas Schmitz
Date:
Subject: Re: ERROR: deadlock detected
Next
From: Jose Antonio Martinez
Date:
Subject: hide pg_user howto