Re: System commands

Didn't know about that one. Thanks.

Syd


Brett Schwarz wrote:

> 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
>