Stabilize regtests aganst testing environment.

[pgdbmsstats/pg_dbms_stats.git] / expected / ut-common.out

diff --git a/expected/ut-common.out b/expected/ut-common.out
index e88582c..1540efd 100644 (file)
--- a/expected/ut-common.out
+++ b/expected/ut-common.out
@@ -1541,10 +1541,21 @@ SELECT count(*) FROM dbms_stats.relation_stats_backup;
      1
 (1 row)
 
-SELECT dbms_stats.backup(1, 's0.st0'::regclass, NULL);
-ERROR:  duplicate key value violates unique constraint "relation_stats_backup_pkey"
-DETAIL:  Key (id, relid)=(1, 16687) already exists.
-CONTEXT:  SQL function "backup" statement 1
+-- SELECT dbms_stats.backup(1, 's0.st0'::regclass, NULL);
+-- To avoid test unstability caused by relation id allocation, unique
+-- constraint which used to be checked above is now checked more
+-- directly in the following step.
+SELECT ic.relname idxname, i.indisprimary
+ FROM pg_index i
+ JOIN pg_class c ON (c.oid = i.indrelid)
+ JOIN pg_namespace n ON (n.oid = c.relnamespace)
+ JOIN pg_class ic ON (ic.oid = i.indexrelid)
+ WHERE n.nspname = 'dbms_stats' AND c.relname = 'relation_stats_backup';
+          idxname           | indisprimary 
+----------------------------+--------------
+ relation_stats_backup_pkey | t
+(1 row)
+
 SELECT count(*) FROM dbms_stats.relation_stats_backup;
  count 
 -------