On Friday 11 Oct 2002 2:48 pm, Stian Riis wrote: > Hi. > > Does anyone know if it is posible to make a trigger that execute an > external program ? I want to execute a another program on the server > when I get a row in one of my tables...
The customary way is to have a "helper" process that sits there LISTENing for a NOTICE and then calls the external program as required. Cleaner and means the other program doesn't have any direct connection to the Postgresql backend. - Richard Huxton ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly