Обсуждение: PostgreSQL problem with Triggers
Hi,
I am trying to implement a trigger in PostgreSQL. My trigger is a C function which do some very simple things like writing to a file when the trigger is fired.
The trigger has been created as an "after insert" or "after update" on a particular table.
However, whenever I perform an insert or update on the table, I get the following:
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
The insert or update also is not reflected in the actual table while my trigger function (written in C) is executed. I am using postgreSQL version 7.2.1-5
Any help in this regard would be highly appreciated.
Regards
Arindam
**************************Disclaimer************************************ Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individualor entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. *************************************************************************** |
MessageCan you please mention on which OS are you working? And also provide the code. Regards, Kallol. -----Original Message----- From: pgsql-bugs-owner@postgresql.org [mailto:pgsql-bugs-owner@postgresql.org]On Behalf Of arindam banerjee Sent: Sunday, June 22, 2003 10:54 PM To: pgsql-bugs@postgresql.org; pgsql-cygwin@postgresql.org; tgl@sss.pgh.pa.us Subject: [BUGS] PostgreSQL problem with Triggers Hi, I am trying to implement a trigger in PostgreSQL. My trigger is a C function which do some very simple things like writing to a file when the trigger is fired. The trigger has been created as an "after insert" or "after update" on a particular table. However, whenever I perform an insert or update on the table, I get the following: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. The insert or update also is not reflected in the actual table while my trigger function (written in C) is executed. I am using postgreSQL version 7.2.1-5 Any help in this regard would be highly appreciated. Regards Arindam **************************Disclaimer************************************ Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ***************************************************************************