From: | "Darrin Ladd" <darrin_ladd(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Trigger Problems? |
Date: | 2000-12-06 00:29:44 |
Message-ID: | LC1-LFD174Rjh0mgmyk000002b7@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Christophe Boggio | 2000-12-06 01:06:01 | Many postmasters... |
Previous Message | thomas wong | 2000-12-06 00:25:13 | Re: Virus spread using pgsql mailling list :-? |