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(at)Yahoo(dot)com #
>
>
>
>_________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>