i have to call one c function users() present in one c file which is as follows:
#include <stdio.h> #include "pgsql/postgres.h" void users(); int main() { users(); } void users() { FILE *fp; fp = fopen("/home/suresh/trigger/test.txt","w"); fputs("Hello this is c function",fp); } the funcion that calls users() from c file is as follows: create FUNCTION users() returns opaque as '/var/lib/pgsql/test.so' language 'C'; the trigger that calls this fuction is as follows: CREATE TRIGGER users_trg before insert on users for each row execute procedure users(); now when i am any value in my table it gives the 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. i cannot find the solution to this problem. please help. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly