Re: Regression tests of plain 7.0.2 fails - Mailing list pgsql-general

Tom Lane schrieb:
> 100.179370@germanynet.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
transactionsrandom 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