HOLY S**T!
<rant>
You are basically setting yourself up for a MICROSOFT sized security
hole. Can you say, "Seeqwell Server?"
You'd be MUCH better off using a PHP, PERL, ASP, JAVA, COLD FUSION, etc.
script for doing that. THOSE places are the focus for much work in
preventing the misuse of system resources from an end user perspective.
DATABASES are for holding data, and their relationships.
</rant>
"Fontenot, Paul" wrote:
>
> Is there a good, hold your hand type of tutorial or howto on creating
> functions and triggers and using them together? I'm learning PostgreSQL
> after spending years with MySQL and the information at
> techdocs.postgresql.org - while good, is a little deep for me right now.
> Specificly I would like to be able to read something that will tell me
> how to create a function that will can run a shell script when certain
> words are entered into a record. Thanks for your time and guidance.
>
> ***PRIVILEGED & CONFIDENTIAL***
> Unless expressly stated otherwise, this message (and any attachment(s)
> thereto) is confidential and may be privileged. It is intended for the
> addressee(s) only. If you are not an addressee, any disclosure or
> copying of the contents of this e-mail or any action taken (or not
> taken) in reliance on it is strictly prohibited. If you are not an
> addressee, please inform sender immediately and delete this message from
> your system.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html