From: | "Darrin Ladd" <dladd(at)newfoundcomm(dot)net> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Trigger Problems? |
Date: | 2000-12-06 17:35:16 |
Message-ID: | 00c801c05faa$e57f0600$0e040a0a@dirge.NEWFOUND |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I sent an e-mail to the mailing list yesterday, but then realized that I sent it using my other account, which may not be able to post to the list.
It seems that I have found myself in a little bit of trouble. I was wondering if there is anyone out there that can help me. Unfortunately, I am quite sure that I will not provide enough information to diagnose the problem, because I don't really know where to start. But, here is what I do know: Yesterday, I decided that it was time to get rid of five tables in my db that were not being used. I proceeded to drop all five tables. I then remembered that there were insert triggers on existing tables which called a function which updated the dropped tables. So then I dropped the function and the triggers. All of this seemed to be successful, but then I hit a serious problem. Any attempt to manipulate data (anything but a select) in the still existing tables which had the triggers removed from them aborts with 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 is not good. I have vacuum analyzed the db and that seemed to have processed fine. If someone could point me in a good direction to figure out what is causing this, I would greatly appreciate it. I am not opposed to dropping the bad tables and restoring from backups, but I am still interested in finding out what is wrong and what I did wrong so that I don't do it again.
Thank you very much for your help!
Darrin
From | Date | Subject | |
---|---|---|---|
Next Message | Daniele Orlandi | 2000-12-06 17:39:46 | Re: AW: beta testing version |
Previous Message | Larry Rosenman | 2000-12-06 17:30:50 | Re: How To Log User Name + Database? |