pgsql: Change test tables in copy2 regression test to be temporary - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Change test tables in copy2 regression test to be temporary
Date
Msg-id 20090614000030.CCEE575331E@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Change test tables in copy2 regression test to be temporary tables.
This prevents autovacuum from reclaiming free space in them and causing
the test's output row order to change, which is causing intermittent
bogus failure reports in the buildfarm.

Backpatch to 8.3.  The issue exists further back, but since autovacuum was
not on by default before 8.3, it's not a problem for buildfarm testing.

Tags:
----
REL8_3_STABLE

Modified Files:
--------------
    pgsql/src/test/regress/expected:
        copy2.out (r1.25 -> r1.25.4.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/copy2.out?r1=1.25&r2=1.25.4.1)
    pgsql/src/test/regress/sql:
        copy2.sql (r1.16 -> r1.16.4.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/copy2.sql?r1=1.16&r2=1.16.4.1)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Change test tables in copy2 regression test to be temporary
Next
From: dim@pgfoundry.org (User Dim)
Date:
Subject: prefix - prefix: Cover all implemented operators in the README, which is