Have you renamed any tables used in the foreign keys
(or dumped and restored with different names or some
missing tables). Under 7.0.2 and earlier there is
a problem with postgres crashing if a constraint trigger
has bad values (due to renames or incomplete restores).
This should be fixed for 7.1 with a message that it's
unable to find the tablename. I believe that if you
look through the archives (I forget which list though),
you will find a patch for 7.0.2 that will turn the
crash into an exception message with more information.
Stephan Szabo
sszabo@bigpanda.com
On Tue, 10 Oct 2000, lt wrote:
> Hi,
> I am using Postgresql 7.0.2, and have used some foreign key in my database, but I get some error like "the backend
endedthe connection" where I am trying to insert or delete a row to the master table(Delete cascade and update
cascade).Of course, this error is no use to find the reason. So I am forced to forget foreign keys.
>