From 5b2e5fed503fd07f3ab7f1ebf8d93ef39b9fd83b Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 14 Jun 2009 00:00:30 +0000 Subject: [PATCH] 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. --- src/test/regress/expected/copy2.out | 4 ++-- src/test/regress/sql/copy2.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/src/test/regress/expected/copy2.out b/src/test/regress/expected/copy2.out index 7759a411cd..7f374ac1a6 100644 --- a/src/test/regress/expected/copy2.out +++ b/src/test/regress/expected/copy2.out @@ -1,4 +1,4 @@ -CREATE TABLE x ( +CREATE TEMP TABLE x ( a serial, b int, c text not null default 'stuff', @@ -172,7 +172,7 @@ I'm null before trigger fired 3 after trigger fired 4 after trigger fired 5 after trigger fired -CREATE TABLE y ( +CREATE TEMP TABLE y ( col1 text, col2 text ); diff --git a/src/test/regress/sql/copy2.sql b/src/test/regress/sql/copy2.sql index b193388ab8..7c23ba253c 100644 --- a/src/test/regress/sql/copy2.sql +++ b/src/test/regress/sql/copy2.sql @@ -1,4 +1,4 @@ -CREATE TABLE x ( +CREATE TEMP TABLE x ( a serial, b int, c text not null default 'stuff', @@ -116,7 +116,7 @@ COPY x TO stdout; COPY x (c, e) TO stdout; COPY x (b, e) TO stdout WITH NULL 'I''m null'; -CREATE TABLE y ( +CREATE TEMP TABLE y ( col1 text, col2 text ); -- 2.50.1