Trigger Problems?

Started by Darrin Laddover 25 years ago1 messagesgeneral
Jump to latest
#1Darrin Ladd
darrin_ladd@hotmail.com

Howdy,

I have found myself in a little bit of trouble here, and I was wondering if
anyone could help me out. Unfortunately, I am pretty sure that I am not
going to provide enough information right off, because I am not really sure
where to look to figure out what is going on. But here is what I do know:

Earlier today I decided that I was finally going to get rid of five unused
tables in my db. I dropped the tables and then remembered that there were
insert triggers on other, existing, tables which called a function which
updated these five tables. So, then I dropped the function and the five
triggers. Now, whenever I try to do anything other than select from the
existing tables which had the triggers associated with them, I get the
following error:

pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Obviously this isn't good. I immediately vacuum analyzed the db and that
seemed to go fine. If anyone can help me diagnose this problem and point me
in the right direction, I would greatly appreciate it. I am not against
just dropping the existing tables and re-creating them off of a backup, but
I would much rather figure out what I did to cause this so I don't do it
again.

Thank you very much!
Darrin
_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com