Re: [GENERAL] Determining weather a query fired a trigger

2008-04-08 Thread Craig Ringer
Gordon wrote: So what I want to know is, is there a way to tell if executing a query caused a trigger to fire? I don't need anything fancy like notify and listen, I just want to see what the database is doing for testing purposes. For example by looking at the logs and seeing what activity wa

Re: [GENERAL] Determining weather a query fired a trigger

2008-04-08 Thread Richard Huxton
Gordon wrote: I'm adding full text search to a CMS project after we upgraded to 8.3 of Postgres. I'd like to do a bit of testing before deploying it. I added columns to the pertinent tables for storing tsvectors, and was looking at my query code to update it so these columns get updated where a

Re: [GENERAL] Determining weather a query fired a trigger

2008-04-08 Thread Martijn van Oosterhout
On Tue, Apr 08, 2008 at 07:03:07AM -0700, Gordon wrote: > But I do have one concern regarding performance. The tsvector only > needs to be updated if the title, summary, or keywords fields have > changed. If they are the same after an update then there is no need > to run them. Doing so would on