Julien Rouhaud <rjuju...@gmail.com> writes: > ... Note that you don't really need to enable > pg_stat_statements, enabling compute_query_id is enough. The query > identifier is only displayed for EXPLAIN (VERBOSE), so it's already a > bit filtered. I don't see any simple way to entirely avoid the > problem though.
> There are already many options that can break the regression tests, so > maybe it's ok to accept that this is yet another one. Yeah, that's my reaction. We could add "compute_query_id = off" to the database-level settings set up by pg_regress, but that cure seems worse than the disease. It would make it impossible to run the regression tests with pg_stat_statements loaded, which you might wish to do (just ignoring the bogus test failures) as a way of testing pg_stat_statements. regards, tom lane