Re: Stored Procedures for Shell Execution

On Mon, Jun 17, 2002 at 01:06:53PM +0000, Dustin Dortch wrote:
> Recently, I have been working on the MCSE certification, and I have been
> studying SQL Server 2000 Administration for one of my electives. Anyhow,
> the reason I mention this is because of some features in SQL Server that I
> think would be great in PostgreSQL. Is there a stored procedure that allows
> for the execution of shell commands? I think it would be great. What I
> would like to accomplish is when a customer is added to my CRM application,
> a script is executed on my shell. Obviously, I woud need to create a
> trigger on my user table and have it run a stored procedure, etc.

Not that I think this is a good idea (I think it's terrible, DB permissions
are not sufficient to control that sort of thing IMHO), but this is already
possible using the untrusted versions of one of the embedded scripting
languages. I think there's even a module in contrib to do it.

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.