Return-Path: hartzell
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA06271; Thu, 10 Jun 93 08:35:00 -0700
Date: Thu, 10 Jun 93 08:35:00 -0700
Message-Id: <9306101535.AA06271@postgres.Berkeley.EDU>
From: George Hartzell <hartzell@postgres.berkeley.edu>
Subject: Re: Is notification possible using rules and fns?
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
References: <9306100533.AA04290@postgres.Berkeley.EDU>
Reply-To: hartzell@cs.berkeley.edu (George Hartzell)

Alfredo Sanchez writes:
   >[...]
   >The C function is a trial one:
   >[...]
   > printf("Document status has been changed");
   >[...]
   >What happens to the function's output?

I can't help you with the rules part of your question, but the
disappearing printf is right up my alley.

Functions that are dynamically loaded run in the back end (which may
well be on another machine...), so the printf isn't doing what you
expect.  If you change it to:

  elog(NOTICE, "Document status has been changed");

then you should see the message.  You'd better check the syntax of the
elog(), since I'm operating from home, but I think that's it.

g.
George Hartzell                                     hartzell@cs.berkeley.edu
Computer Science, 570 Evans Hall,
University of California, Berkeley, CA 94720