Look at peter eisentraut's procedural language PL/sh It's on pgfoundry. ... John
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane > Sent: Saturday, June 04, 2005 5:16 AM > To: Gevik babakhani > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] executing OS programs from pg > > "Gevik babakhani" <[EMAIL PROTECTED]> writes: > > Does anyone know how to execute an OS command from pgsql. I > would like > > to create a trigger that op on firing would run/execute an > external program. > > Use any of the "untrusted" PLs to execute system() or the like. > > Whether this is a good idea or not is a different question > --- there are excellent reasons why it is a *bad* idea to > execute outside-the-database actions from within a trigger. > Mainly that the actions won't be undone if the transaction > later rolls back, and now your database state is inconsistent > with outside-the-database state. See the list archives for > many past discussions of this point and safer ways to design > your application. > > (BTW, this is hardly material for -hackers.) > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster