Trigger Problems?
От | Darrin Ladd |
---|---|
Тема | Trigger Problems? |
Дата | |
Msg-id | LC1-LFD174Rjh0mgmyk000002b7@hotmail.com обсуждение исходный текст |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: