Re: [GENERAL] starting a stored procedure+rule AFTER an insert

2007-10-09 Thread Bima Djaloeis
Thanks for the reply, is there any online reference / tutorial for this? -BD 2007/10/8, Douglas McNaught <[EMAIL PROTECTED]>: > > "Bima Djaloeis" <[EMAIL PROTECTED]> writes: > > > I have implemented a stored procedure that writes out the newest DB > > e

[GENERAL] starting a stored procedure+rule AFTER an insert

2007-10-08 Thread Bima Djaloeis
Hi, Newbie here, I have implemented a stored procedure that writes out the newest DB entry on insert, and combined it with a rule. 1) create function newcache() returns void AS 'newCache', 'newCache' language c; 2) create rule newcacherule AS on insert to caches do also select newcache(); The pr

[GENERAL] ON INSERT => execute AWK/SH/EXE?

2007-09-18 Thread Bima Djaloeis
Hi there, I am new to PostgreSQL, is it possible to create something so that 1) If I insert / update / delete an item from my DB... 2) ... an awk / shell / external program is executed in my UNIX System? If yes, how do I do this and if no, thanks for telling. Thanks for reading, any help is app