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 problem is that newcacherule fires BEFORE the insert has taken place, so effectively, I always just get the 2nd newest entry to write into my text file while the newest entry is "stuck in the queue" until a new insert come. How can I execute my rule AFTER the insert has taken place?
