Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D64CB6351A0 for ; Sat, 13 Jun 2009 21:00:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 41519-01 for ; Sat, 13 Jun 2009 21:00:33 -0300 (ADT) Received: from cvs.postgresql.org (cvs.postgresql.org [217.196.146.206]) by mail.postgresql.org (Postfix) with ESMTP id 4A73863517C for ; Sat, 13 Jun 2009 21:00:32 -0300 (ADT) Received: by cvs.postgresql.org (Postfix, from userid 1007) id CCEE575331E; Sun, 14 Jun 2009 00:00:30 +0000 (UTC) MIME-Version: 1.0 To: pgsql-committers@postgresql.org Subject: pgsql: Change test tables in copy2 regression test to be temporary X-Mailer: activitymail 1.24, http://search.cpan.org/dist/activitymail/ Content-Type: text/plain Message-Id: <20090614000030.CCEE575331E@cvs.postgresql.org> Date: Sun, 14 Jun 2009 00:00:30 +0000 (UTC) From: tgl@postgresql.org (Tom Lane) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200906/209 X-Sequence-Number: 37413 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)