Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 35A4F63513F for ; Sat, 13 Jun 2009 21:00:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 59067-06 for ; Sat, 13 Jun 2009 21:00:29 -0300 (ADT) Received: from cvs.postgresql.org (cvs.postgresql.org [217.196.146.206]) by mail.postgresql.org (Postfix) with ESMTP id 12F8C633A4B for ; Sat, 13 Jun 2009 21:00:26 -0300 (ADT) Received: by cvs.postgresql.org (Postfix, from userid 1007) id 433BC75331E; Sun, 14 Jun 2009 00:00:24 +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: <20090614000024.433BC75331E@cvs.postgresql.org> Date: Sun, 14 Jun 2009 00:00:24 +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/208 X-Sequence-Number: 37412 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. Modified Files: -------------- pgsql/src/test/regress/expected: copy2.out (r1.25 -> r1.26) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/copy2.out?r1=1.25&r2=1.26) pgsql/src/test/regress/sql: copy2.sql (r1.16 -> r1.17) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/copy2.sql?r1=1.16&r2=1.17)