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
