Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA19802; Mon, 13 Apr 92 13:49:31 -0700
Date: Mon, 13 Apr 92 13:49:31 -0700
From: "Raymond Frost (305) 284-3969" <RFROST@umiami.IR.Miami.EDU>
Subject: C functions
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: postgres@postgres.berkeley.edu
Message-Id: <01GIT0NZLSQ8984VWG@umiami.IR.Miami.EDU>
X-Envelope-To: postgres@postgres.berkeley.edu
X-Vms-To: IN%"postgres@postgres.berkeley.edu"

The dynamic loader seems to object to the system call on the following
c function.  Is there a way around this?  Also is there a way to pass
control to a c program in the action part of a rule?

int warning(patient)
int patient;
{
        system("mail < warning postgres\n");
        return (patient);
}
/u/rfrost/postgres/demo> monitor test
Welcome to the C POSTGRES terminal monitor

Query sent to backend is "define function warning (   language = "c",                              returntype = int4)       arg is (int4)      as "/u/rfrost/postgres/demo/m.o" "
DEFINE
Query sent to backend is "load "/u/rfrost/postgres/demo/m.o" "
WARN:Apr 13 01:09:44:dynamic_loader: Illegal ext. symbol system
 

Raymond Frost
University of Miami