Re: ERROR: deadlock detected ->referential integrity violation

From: Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de>
To: a(dot)schmitz(at)cityweb(dot)de, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: ERROR: deadlock detected ->referential integrity violation
Date: 2003-02-13 10:37:29
Message-ID: 200302131137.29569.a.schmitz@cityweb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)schmitz(at)cityweb(dot)de

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jason Tishler 2003-02-13 12:18:22 Re: configure: error: no acceptable C compiler found in $PATH
Previous Message Andreas Schmitz 2003-02-13 09:04:20 Re: ERROR: deadlock detected