SEO

#1 (**permalink**) 04-15-2008, 10:28 PM

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

#2 (**permalink**) 04-15-2008, 10:28 PM

qljsystems@zoom.co.uk writes:
> There's a suggested function in pltclu to send emails from the postgre database.

There's no such function anywhere in the core Postgres distribution,
so I think you've reported this to the wrong place.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

I've discovered an error with the tcl pgmail function