For some reason the cluster test fails on my machine due to a different
order of the result rows when I run "installcheck" instead of "check". Is
there a problem adding an ORDER BY to it?

Joachim

Index: src/test/regress/sql/cluster.sql
===================================================================
RCS file: /projects/cvsroot/pgsql/src/test/regress/sql/cluster.sql,v
retrieving revision 1.11
diff -c -r1.11 cluster.sql
*** src/test/regress/sql/cluster.sql	8 Apr 2007 01:26:33 -0000	1.11
--- src/test/regress/sql/cluster.sql	25 May 2007 12:20:34 -0000
***************
*** 73,79 ****
  -- Verify that foreign key link still works
  INSERT INTO clstr_tst (b, c) VALUES (1111, 'this should fail');
  
! SELECT conname FROM pg_constraint WHERE conrelid = 'clstr_tst'::regclass;
  
  
  SELECT relname, relkind,
--- 73,79 ----
  -- Verify that foreign key link still works
  INSERT INTO clstr_tst (b, c) VALUES (1111, 'this should fail');
  
! SELECT conname FROM pg_constraint WHERE conrelid = 'clstr_tst'::regclass ORDER BY conname;
  
  
  SELECT relname, relkind,
Index: src/test/regress/expected/cluster.out
===================================================================
RCS file: /projects/cvsroot/pgsql/src/test/regress/expected/cluster.out,v
retrieving revision 1.19
diff -c -r1.19 cluster.out
*** src/test/regress/expected/cluster.out	8 Apr 2007 01:26:33 -0000	1.19
--- src/test/regress/expected/cluster.out	25 May 2007 12:20:34 -0000
***************
*** 249,259 ****
  INSERT INTO clstr_tst (b, c) VALUES (1111, 'this should fail');
  ERROR:  insert or update on table "clstr_tst" violates foreign key constraint "clstr_tst_con"
  DETAIL:  Key (b)=(1111) is not present in table "clstr_tst_s".
! SELECT conname FROM pg_constraint WHERE conrelid = 'clstr_tst'::regclass;
      conname     
  ----------------
-  clstr_tst_pkey
   clstr_tst_con
  (2 rows)
  
  SELECT relname, relkind,
--- 249,259 ----
  INSERT INTO clstr_tst (b, c) VALUES (1111, 'this should fail');
  ERROR:  insert or update on table "clstr_tst" violates foreign key constraint "clstr_tst_con"
  DETAIL:  Key (b)=(1111) is not present in table "clstr_tst_s".
! SELECT conname FROM pg_constraint WHERE conrelid = 'clstr_tst'::regclass ORDER BY conname;
      conname     
  ----------------
   clstr_tst_con
+  clstr_tst_pkey
  (2 rows)
  
  SELECT relname, relkind,
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to