Re: Trigger sending an eMail

On Mon, Feb 26, 2001 at 06:09:58PM -0300, Tulio Oliveira wrote:
> How is the best form of a trigger send an email ?
>
> I'll need make the trigger in C or the plpgsql has any mail function ?

#if !defined(_PATH_SENDMAIL)
# define _PATH_SENDMAIL "/usr/lib/sendmail"
#endif /*SENDMAIL*/
#define MAILCMD _PATH_SENDMAIL
#define MAILARGS "%s -Fpostgres -oem -t"

/* send notification e-mail
*/
static int sendmail(char * mailto, char * subject, char * mess) {

register FILE *mail;
char * mailcmd;

asprintf(&mailcmd, MAILARGS, MAILCMD);
if (!(mail = popen(mailcmd, "w"))) {
elog(ERROR, "Couldn't run command %s", MAILCMD);
(void) _exit(ERROR_EXIT);
}
free(mailcmd);
fprintf(mail, "From: Apartia Auction Daemon <root(at)apartia(dot)com>\n");
fprintf(mail, "To: ldm(at)apartia(dot)com\n");
fprintf(mail, "Subject: %s\n", subject);
fprintf(mail, "User-Agent: to %s\n", mailto);
fprintf(mail, "\n");
fprintf(mail, mess);
fprintf(mail, "\n.\n");

return pclose(mail);
}

--
-= this .sig is not funny =-