Le jeudi 20 décembre 2007, Decibel! a écrit : > A work-around others have used is to have the trigger just insert > into a 'staging' table and then periodically take the records from > that table and summarize them somewhere else.
And you can even use the PgQ skytools implementation to easily have this kind of 'staging'-table with a producer and one or many subscribers. See those references if you're interrested: http://kaiv.wordpress.com/2007/10/19/skytools-database-scripting-framework-pgq/ http://skytools.projects.postgresql.org/doc/pgq-sql.html http://skytools.projects.postgresql.org/doc/pgq-admin.html http://skytools.projects.postgresql.org/doc/pgq-nodupes.html Hope this helps, regards, -- dim
signature.asc
Description: This is a digitally signed message part.
