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(at)Yahoo(dot)com #

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