pgsql: Add ANALYZE into regression tests - Mailing list pgsql-committers

From Stephen Frost
Subject pgsql: Add ANALYZE into regression tests
Date
Msg-id E1WZCFS-0006Dy-GB@gemulon.postgresql.org
Whole thread Raw
Responses Re: pgsql: Add ANALYZE into regression tests  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-committers
Add ANALYZE into regression tests

Looks like we can end up with different plans happening on the
buildfarm, which breaks the regression tests when we include
EXPLAIN output (which is done in the regression tests for
updatable security views, to ensure that the user-defined
function isn't pushed down to a level where it could view the
rows before the security quals are applied).

This adds in ANALYZE to hopefully make the plans consistent.
The ANALYZE ends up changing the original plan too, so the
update looks bigger than it really is.  The new plan looks
perfectly valid, of course.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/b3e6593716efef901fcc847f33256c6b49958898

Modified Files
--------------
src/test/regress/expected/updatable_views.out |  232 +++++++++++--------------
src/test/regress/sql/updatable_views.sql      |    4 +
2 files changed, 102 insertions(+), 134 deletions(-)


pgsql-committers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: pgsql: Make security barrier views automatically updatable
Next
From: Stephen Frost
Date:
Subject: pgsql: Make a dedicated AlterTblSpcStmt production