Re: System commands

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