Re: System commands

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
>