Re: System commands

pgmail won't do what you want? If nothing else, it might give you an idea
on how to roll your own...

http://sourceforge.net/projects/pgmail/


On Thu, 31 Jan 2002 19:23:35 -0500
Syd Alsobrook <syd@ittagteam.com> wrote:

> I want to be able to trigger an email to be sent. I understand the
> security concerns, I have seen this done in the past with oracle. We had
> our database doing the backups from a sql script. Would it have to be in
> C or could I use another language?
>
> Syd
>
>
> Jan Wieck wrote:
>
> >Syd Alsobrook wrote:
> >
> >>That's from psql, what about from a trigger or stored procedure.
> >>
> >>Syd
> >>
> >>
> >>omid omoomi wrote:
> >>
> >> > using \!
> >>
> >
> >    Don't  know  what you need that for, but are you aware of all
> >    the side effects and implications such a functionality  would
> >    have?  The  command  you'd be calling will be executed by the
> >    database system owner, so it'd have access to  all  files  of
> >    the entire database instance without any access restrictions.
> >
> >    Also, the command  will  be  called  regardless  and  without
> >    further  notice  of  an  eventually later happening ROLLBACK.
> >    Does your filesystem have a ROLLBACK for unlink(2)?
> >
> >    If that is really what you want, you can write a  C  function
> >    and  use system(3) in there. But remember that this opens the
> >    flood gate for everything that is  owned  by  the  unix  user
> >    running  that  postmaster, not only the databases you declare
> >    the function in.
> >
> >
> >Jan
> >
> >--
> >
>
>#======================================================================#>
># It's easier to get forgiveness for being wrong than for being right. #>
># Let's break this rule - forgive me.                                  #>
>#================================================== JanWieck@Yahoo.com #>
>> >
> >
> >_________________________________________________________
> >Do You Yahoo!?
> >Get your free @yahoo.com address at http://mail.yahoo.com
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com