PostgreSQL problem with Triggers

From: "arindam banerjee" <arindam(dot)banerjee(at)wipro(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>, <pgsql-cygwin(at)postgresql(dot)org>, <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: PostgreSQL problem with Triggers
Date: 2003-06-22 17:24:02
Message-ID: 94F20261551DC141B6B559DC491086726192DF@blr-m3-msg.wipro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-cygwin


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.

***************************************************************************

Browse pgsql-bugs by date

  From Date Subject
Next Message Enke, Michael 2003-06-23 08:02:46 Re: [HACKERS] again: Bug #943: Server-Encoding from EUC_TW toUTF-8
Previous Message Theodore Petrosky 2003-06-21 20:00:11 Re: Posgres bug report

Browse pgsql-cygwin by date

  From Date Subject
Next Message Diogo de Oliveira Biazus 2003-06-23 13:32:01 Re: Problems compiling PostgreSQL 7.3.3-1 under Win98
Previous Message Jason Tishler 2003-06-22 02:43:44 Re: Problems compiling PostgreSQL 7.3.3-1 under Win98