Re: [GENERAL] the best way to catch table modification

2005-10-26 Thread Janning Vygen
Am Dienstag, 25. Oktober 2005 19:40 schrieb David Gagnon: > Hi, > > I posted on the same subject a month ago . .you can search for the > current title in the JDBC mailing list > [JDBC] implementing asynchronous notifications PLEASE CONFIRM MY > > I ended using statement-level trigger. I haven't

Re: [GENERAL] the best way to catch table modification

2005-10-25 Thread David Gagnon
Hi, I posted on the same subject a month ago . .you can search for the current title in the JDBC mailing list [JDBC] implementing asynchronous notifications PLEASE CONFIRM MY I ended using statement-level trigger. I haven't found another way to do it . Regards /David Marek Lewczuk wrote:

[GENERAL] the best way to catch table modification

2005-10-25 Thread Marek Lewczuk
Hello, I'm implementing db-queries caching system - for this I need to know each table's modification time (or at least modification counter). I know that I can make a statement-level trigger, which will update a table with tables modification times - however this is inefficient if many insert