Further to the thread Re: Send email from PostgreSQL, may I ?
* From: Devrim GUNDUZ <devrim ( at ) commandprompt ( dot ) com> * To: Gerson Machado <gersonamach ( at ) yahoo ( dot ) com ( dot ) br> * Subject: Re: Send email from PostgreSQL, may I ? * Date: Fri, 27 Oct 2006 16:07:00 +0300 There's a suggested function in pltclu to send emails from the postgre database. I've worked with this and discovered that there's an error which causes the email to be sent with a blank subject and the subject to be included as part of the body. To overcome this, the following should be done: comment out or remove the two lines:- puts $ServerSocket "To: $mailto" ;# To: puts $ServerSocket "From: $mailfrom" ;# From: Regards, Quentin ----------------------------------------------- This mail sent through http://webmail.zoom.co.uk ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster