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:
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 inserts or updates are made on single table (in single
transaction). The best would be some kind of transaction-level
trigger, but this is not available. Are there any other, better options ?
Thanks in advance.
ML
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
