It looks like the indexes are in fact used when trigger variables are
referenced in where clauses in PL/pgSQL. Thanks for the idea of
investigating the plans in the logs for this info.
Follow-up question: are indexes used in dynamically executed queries?
Rather than SEQSCAN or INDEXSCAN in the DETAIL item, I see RESULT
followed by a large amount of unreadable (by me) output.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005