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
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
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