Re: [ADMIN] foreign key question: the backend end the connection

2000-10-10 Thread Gavin M. Roy
This happens for me when the tables referenced in the foreign key don't exisit.  Hope that helps! Gavin 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 ended the connection" where I am trying to insert or delete

Re: [ADMIN] foreign key question: the backend end the connection

2000-10-10 Thread Stephan Szabo
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.

[ADMIN] foreign key question: the backend end the connection

2000-10-10 Thread lt
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 ended the 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