Re: Regression tests of plain 7.0.2 fails

Tom Lane schrieb:
> 100(dot)179370(at)germanynet(dot)de (Martin Jacobs) writes:
> > Ignoring the minor floatingpoint errors, the first annoying
> > severe was in parallel group2
> > sequential test create_type ... FAILED
>
> > ERROR: TypeCreate: function 'widget_in(opaque)' does not exist
>
> Odd. Test create_function_1 did not fail? That's where the
> function should get created.

No, here is the complete run_check.out:

parallel group1 (12 tests) ...
boolean char name int2 text varchar float4 oid int4 int8 float8 numeric
test boolean ... ok
test char ... ok
test name ... ok
test varchar ... ok
test text ... ok
test int2 ... ok
test int4 ... ok
test int8 ... ok
test oid ... ok
test float4 ... ok
test float8 ... ok
test numeric ... ok
sequential test strings ... ok
sequential test numerology ... ok
parallel group2 (15 tests) ...
point lseg path box polygon reltime circle interval tinterval comments inet timestamp type_sanity opr_sanity oidjoins
test point ... ok
test lseg ... ok
test box ... ok
test path ... ok
test polygon ... ok
test circle ... ok
test interval ... ok
test timestamp ... ok
test reltime ... ok
test tinterval ... ok
test inet ... ok
test comments ... ok
test oidjoins ... ok
test type_sanity ... ok
test opr_sanity ... ok
sequential test abstime ... ok
sequential test geometry ... FAILED
sequential test horology ... ok
sequential test create_function_1 ... ok
sequential test create_type ... FAILED
sequential test create_table ... ok
sequential test create_function_2 ... ok
sequential test copy ... ok
parallel group3 (6 tests) ...
constraints create_operator create_aggregate create_misc triggers create_index
test constraints ... ok
test triggers ... FAILED
test create_misc ... ok
test create_aggregate ... ok
test create_operator ... FAILED
test create_index ... FAILED
sequential test create_view ... FAILED
sequential test sanity_check ... ok
sequential test errors ... ok
sequential test select ... FAILED
parallel group4 (16 tests) ...
select_distinct select_distinct_on select_into select_having union aggregates select_implicit subselect case join transactions random portals btree_index arrays hash_index
test select_into ... ok
test select_distinct ... FAILED
test select_distinct_on ... FAILED
test select_implicit ... ok
test select_having ... ok
test subselect ... ok
test union ... ok
test case ... ok
test join ... ok
test aggregates ... FAILED
test transactions ... FAILED
test random ... FAILED
test portals ... FAILED
test arrays ... ok
test btree_index ... FAILED
test hash_index ... FAILED
sequential test misc ... ok
parallel group5 (5 tests) ...
select_views portals_p2 alter_table foreign_key rules
test select_views ... FAILED
test alter_table ... FAILED
test portals_p2 ... FAILED
test rules ... FAILED
test foreign_key ... ok
parallel group6 (3 tests) ...
limit temp plpgsql
test limit ... FAILED
test plpgsql ... ok
test temp ... ok>
>
> What platform are you using?

It's a linux box, based on SuSE 5.3, kernel 2.0.38, gcc 2.95.2,
libc.so.5.4.46, ...
>
> regards, tom lane
>

Maybe this is of help: here is
src/postgresql-7.0.2/src/test/regress/output/create_function_1.source
this file is dated Jan 9 2000:

--
-- CREATE_FUNCTION_1
--
CREATE FUNCTION widget_in(opaque)
RETURNS widget
AS '_OBJWD_/regress_DLSUFFIX_'
LANGUAGE 'c';
NOTICE: ProcedureCreate: type 'widget' is not yet defined
CREATE FUNCTION widget_out(opaque)
RETURNS opaque
AS '_OBJWD_/regress_DLSUFFIX_'
LANGUAGE 'c';
CREATE FUNCTION check_primary_key ()
RETURNS opaque
AS '_OBJWD_/../../../contrib/spi/refint_DLSUFFIX_'
LANGUAGE 'c';
CREATE FUNCTION check_foreign_key ()
RETURNS opaque
AS '_OBJWD_/../../../contrib/spi/refint_DLSUFFIX_'
LANGUAGE 'c';
CREATE FUNCTION autoinc ()
RETURNS opaque
AS '_OBJWD_/../../../contrib/spi/autoinc_DLSUFFIX_'
LANGUAGE 'c';
CREATE FUNCTION funny_dup17 ()
RETURNS opaque
AS '_OBJWD_/regress_DLSUFFIX_'
LANGUAGE 'c';
CREATE FUNCTION ttdummy ()
RETURNS opaque
AS '_OBJWD_/regress_DLSUFFIX_'
LANGUAGE 'c';
CREATE FUNCTION set_ttdummy (int4)
RETURNS int4
AS '_OBJWD_/regress_DLSUFFIX_'
LANGUAGE 'c';

The file
src/postgresql-7.0.2/src/test/regress/results/create_type.out:

--
-- CREATE_TYPE
--
CREATE TYPE widget (
internallength = 24,
input = widget_in,
output = widget_out,
alignment = double
);
ERROR: TypeCreate: function 'widget_in(opaque)' does not exist
CREATE TYPE city_budget (
internallength = 16,
input = int44in,
output = int44out,
element = int4
);

I did not find a create_functions_1.out file in the results
directory. Even doing a

grep FUNCTION *

fails. Did the create_funcion_1 script run?

This is the results directory (output of ls -lt):

-rw-r--r-- 1 postgres daemon 64999 Oct 10 21:53 plpgsql.out
-rw-r--r-- 1 postgres daemon 773 Oct 10 21:53 temp.out
-rw-r--r-- 1 postgres daemon 1867 Oct 10 21:53 limit.out
-rw-r--r-- 1 postgres daemon 48851 Oct 10 21:53 rules.out
-rw-r--r-- 1 postgres daemon 24796 Oct 10 21:52 foreign_key.out
-rw-r--r-- 1 postgres daemon 5840 Oct 10 21:52 alter_table.out
-rw-r--r-- 1 postgres daemon 5460 Oct 10 21:52 portals_p2.out
-rw-r--r-- 1 postgres daemon 360 Oct 10 21:52 select_views.out
-rw-r--r-- 1 postgres daemon 5506 Oct 10 21:52 case.out
-rw-r--r-- 1 postgres daemon 8347 Oct 10 21:52 join.out
-rw-r--r-- 1 postgres daemon 542 Oct 10 21:52 transactions.out
-rw-r--r-- 1 postgres daemon 889 Oct 10 21:52 random.out
-rw-r--r-- 1 postgres daemon 16622 Oct 10 21:52 portals.out
-rw-r--r-- 1 postgres daemon 2413 Oct 10 21:52 arrays.out
-rw-r--r-- 1 postgres daemon 1361 Oct 10 21:52 btree_index.out
-rw-r--r-- 1 postgres daemon 3761 Oct 10 21:52 hash_index.out
-rw-r--r-- 1 postgres daemon 4690 Oct 10 21:52 subselect.out
-rw-r--r-- 1 postgres daemon 7586 Oct 10 21:52 select_implicit.out
-rw-r--r-- 1 postgres daemon 1724 Oct 10 21:52 aggregates.out
-rw-r--r-- 1 postgres daemon 3473 Oct 10 21:52 union.out
-rw-r--r-- 1 postgres daemon 1144 Oct 10 21:52 select_having.out
-rw-r--r-- 1 postgres daemon 190 Oct 10 21:52 select_into.out
-rw-r--r-- 1 postgres daemon 945 Oct 10 21:52 select_distinct.out
-rw-r--r-- 1 postgres daemon 626 Oct 10 21:52 select_distinct_on.out
-rw-r--r-- 1 postgres daemon 7410 Oct 10 21:52 errors.out
-rw-r--r-- 1 postgres daemon 3252 Oct 10 21:52 select.out
-rw-r--r-- 1 postgres daemon 1367 Oct 10 21:52 sanity_check.out
-rw-r--r-- 1 postgres daemon 641 Oct 10 21:52 create_view.out
-rw-r--r-- 1 postgres daemon 3019 Oct 10 21:52 create_index.out
-rw-r--r-- 1 postgres daemon 7841 Oct 10 21:52 triggers.out
-rw-r--r-- 1 postgres daemon 6412 Oct 10 21:52 create_misc.out
-rw-r--r-- 1 postgres daemon 502 Oct 10 21:52 create_aggregate.out
-rw-r--r-- 1 postgres daemon 578 Oct 10 21:52 create_operator.out
-rw-r--r-- 1 postgres daemon 3218 Oct 10 21:52 create_table.out
-rw-r--r-- 1 postgres daemon 81756 Oct 10 21:52 horology.out
-rw-r--r-- 1 postgres daemon 319 Oct 10 21:52 create_type.out
-rw-r--r-- 1 postgres daemon 5863 Oct 10 21:52 abstime.out
-rw-r--r-- 1 postgres daemon 21855 Oct 10 21:52 geometry.out
-rw-r--r-- 1 postgres daemon 10972 Oct 10 21:52 oidjoins.out
-rw-r--r-- 1 postgres daemon 22489 Oct 10 21:52 opr_sanity.out
-rw-r--r-- 1 postgres daemon 6189 Oct 10 21:52 type_sanity.out
-rw-r--r-- 1 postgres daemon 70533 Oct 10 21:52 timestamp.out
-rw-r--r-- 1 postgres daemon 6832 Oct 10 21:52 inet.out
-rw-r--r-- 1 postgres daemon 2342 Oct 10 21:51 circle.out
-rw-r--r-- 1 postgres daemon 5680 Oct 10 21:51 interval.out
-rw-r--r-- 1 postgres daemon 2751 Oct 10 21:51 reltime.out
-rw-r--r-- 1 postgres daemon 8051 Oct 10 21:51 tinterval.out
-rw-r--r-- 1 postgres daemon 660 Oct 10 21:51 comments.out
-rw-r--r-- 1 postgres daemon 4715 Oct 10 21:51 box.out
-rw-r--r-- 1 postgres daemon 4143 Oct 10 21:51 polygon.out
-rw-r--r-- 1 postgres daemon 1245 Oct 10 21:51 lseg.out
-rw-r--r-- 1 postgres daemon 2101 Oct 10 21:51 path.out
-rw-r--r-- 1 postgres daemon 7841 Oct 10 21:51 point.out
-rw-r--r-- 1 postgres daemon 3500 Oct 10 21:51 numerology.out
-rw-r--r-- 1 postgres daemon 3116 Oct 10 21:51 strings.out
-rw-r--r-- 1 postgres daemon 49002 Oct 10 21:51 numeric.out
-rw-r--r-- 1 postgres daemon 6552 Oct 10 21:49 int4.out
-rw-r--r-- 1 postgres daemon 11574 Oct 10 21:49 int8.out
-rw-r--r-- 1 postgres daemon 8532 Oct 10 21:49 float8.out
-rw-r--r-- 1 postgres daemon 1809 Oct 10 21:49 varchar.out
-rw-r--r-- 1 postgres daemon 4811 Oct 10 21:49 int2.out
-rw-r--r-- 1 postgres daemon 476 Oct 10 21:49 text.out
-rw-r--r-- 1 postgres daemon 1314 Oct 10 21:49 oid.out
-rw-r--r-- 1 postgres daemon 3980 Oct 10 21:49 float4.out
-rw-r--r-- 1 postgres daemon 4884 Oct 10 21:49 boolean.out
-rw-r--r-- 1 postgres daemon 3135 Oct 10 21:49 name.out
-rw-r--r-- 1 postgres daemon 1966 Oct 10 21:49 char.out
-rw-r--r-- 1 postgres daemon 468 Apr 27 1997 Makefile

Any ideas?

Martin Jacobs