Re: RULE regression test fragility? - Mailing list pgsql-hackers

From Andres Freund
Subject Re: RULE regression test fragility?
Date
Msg-id 20131024082325.GF823737@alap2.anarazel.de
Whole thread Raw
In response to Re: RULE regression test fragility?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: RULE regression test fragility?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2013-10-23 20:50:30 -0400, Tom Lane wrote:
> Mike Blackwell <mike.blackwell@rrd.com> writes:
> > While reviewing the Network Stats Traffic patch I discovered the current
> > regression test for rules depends on the system view definitions not
> > changing:
> 
> Yes, this is standard.  We just update the expected output anytime
> somebody changes a system view.

FWIW, I've repeatedly now thought that it'd make maintaining/updating
patches easier if we switched that query into unaligned tuple only (\a
\t) mode. That would remove the frequent conflicts on the row count and
widespread changes due to changed alignment.
Alternatively we could just wrap the query in \copy ... CSV.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: CLUSTER FREEZE
Next
From: Haribabu kommi
Date:
Subject: Regress tests to improve the function coverage of schemacmds and user and tablespace files