Re: [GENERAL] Insert Rewrite rules

2008-04-21 Thread David
I dropped the trigger again and now it works... but it is really slow it was maxing out the cpu doing 26r/s not that this is a big problem because the firewall code wont be reling on the rewrite rules to put the data in the correct spot as it will just insert it into the correct table and I hav

Re: [GENERAL] Insert Rewrite rules

2008-04-21 Thread Klint Gore
David wrote: I am having problems with the rewrite rules though it seems to be skipping over any rule that has a where statement in it ie CREATE OR REPLACE RULE firewall_test AS ON INSERT TO firewall DO INSTEAD INSERT INTO firewall_y2008m04d21 VALUES(NEW."time"); INSERT INTO firewall (time) VA