Philippe Lang wrote:
> I need to send emails from Postgresql triggers.
> I was able to do it with a 'plperlu' function, that calls the 'system'
> perl function, that itself calls the 'mail' shell function.
> Is is safe to do things like this? Is there a possible concurrent access
> that could arise?
Not that I can think of, but "mail" will called as the postgres user,
which opens up a possible security hole.
> Another solution would be to use cron every 5 minutes, and read the
> content of a table.
This is my preferred solution, but there's plenty of discussion in the
archives about this.
In response to
pgsql-general by date
|Next:||From: Richard Huxton||Date: 2004-06-28 09:11:59|
|Subject: Re: postgresql perl connectivity|
|Previous:||From: Richard Huxton||Date: 2004-06-28 09:04:29|
|Subject: Re: Connect to a PostgreSQL table with kylix3|