PostgreSQL 8.2 on IA-64 : 2 regression tests FAILED - Mailing list pgsql-general

Hello List,

I work on an IA-64 server with Red Hat Enterprise Linux 4 AS, and as the
8.2 release is now available, I try to generate RPM for IA-64.
To do that, I downloaded the "postgresql-8.2.0-2PGDG.src.rpm", extracted
the ".spec" file and these files :
-bash-3.00$ cd SOURCES/
-bash-3.00$ ls -ltr
total 24176
-rw-r--r--  1 postgres postgres 12459207 Dec  2 20:25
postgresql-8.2.0.tar.bz2
-rw-r--r--  1 postgres postgres      897 Dec  2 20:28 pg_config.h
-rw-r--r--  1 postgres postgres     1539 Dec  2 20:28 Makefile.regress
-rwxr-xr-x  1 postgres postgres       56 Dec  2 20:28
filter-requires-perl-Pg.sh
-rw-r--r--  1 postgres postgres     1631 Dec  2 20:28
postgresql-logging.patch
-rw-r--r--  1 postgres postgres     7529 Dec  2 20:28 postgresql.init
-rw-r--r--  1 postgres postgres       85 Dec  2 20:28 postgresql-bashprofile
-rw-r--r--  1 postgres postgres     1757 Dec  2 20:28 rpm-pgsql.patch
-rw-r--r--  1 postgres postgres    15598 Dec  2 20:28 README.rpm-dist
-rw-r--r--  1 postgres postgres     2563 Dec  2 20:28 postgresql-test.patch
-rw-r--r--  1 postgres postgres      919 Dec  2 20:28
postgresql-perl-rpath.patch
-rw-r--r--  1 postgres postgres      141 Dec  2 20:28 postgresql.pam
-rw-r--r--  1 postgres postgres 12198114 Dec  6 17:18
postgresql-8.2.0-2PGDG.src.rpm

Then, as the "postgres" user, I launched the command : rpmbuild -ba
postgresql-8.2.spec
By doing this, all the RPM had been created on /RPMS/ia64.

Now, I try to launch the regression tests and 2 of them failed :
test create_function_1    ... FAILED
... ... ...
triggers             ... FAILED

I see at http://archives.postgresql.org/pgsql-ports/2006-11/msg00011.php
that this problem already appear on 64 bits but I am note sure that it
is the same problem...

In the file "regression.diff", my first problem seems to be linked with
the function "autoinc()" :
*** ./expected/create_function_1.out    Thu Dec  7 14:37:28 2006
--- ./results/create_function_1.out    Thu Dec  7 14:41:21 2006
***************
*** 25,40 ****
  NOTICE:  argument type city_budget is only a shell
  CREATE FUNCTION check_primary_key ()
      RETURNS trigger
!     AS
'/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/../../../contrib/spi/refint.so
      LANGUAGE C;
  CREATE FUNCTION check_foreign_key ()
      RETURNS trigger
!     AS
'/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/../../../contrib/spi/refint.so
      LANGUAGE C;
  CREATE FUNCTION autoinc ()
      RETURNS trigger
!     AS
'/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/../../../contrib/spi/refint.so
      LANGUAGE C;
  CREATE FUNCTION funny_dup17 ()
          RETURNS trigger
          AS
'/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/regress.so'
--- 25,41 ----
  NOTICE:  argument type city_budget is only a shell
  CREATE FUNCTION check_primary_key ()
      RETURNS trigger
!     AS
'/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/../../../contrib/spi/refint.so'
      LANGUAGE C;
  CREATE FUNCTION check_foreign_key ()
      RETURNS trigger
!     AS
'/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/../../../contrib/spi/refint.so'
      LANGUAGE C;
  CREATE FUNCTION autoinc ()
      RETURNS trigger
!     AS
'/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/../../../contrib/spi/refint.so'
      LANGUAGE C;
*+ ERROR:  could not find function "autoinc" in file
"/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/../../../contrib/spi/refint.so"*

I checked the file "contrib/spi/refint.c" : it does not contain a
function called autoinc...

The two others errors reported in "regression.diff" are :
  delete from tttest where price_id = 2;
  select * from tttest;
   price_id | price_val | price_on | price_off
  ----------+-----------+----------+-----------
!         1 |         1 |       10 |    999999
!         3 |         3 |       30 |    999999
!         2 |         2 |       20 |        40
  (3 rows)

  -- what do we see ?
--- 150,175 ----
      for each row
      execute procedure
      autoinc (price_on, ttdummy_seq);
*+ ERROR:  function autoinc() does not exist*
  insert into tttest values (1, 1, null);
  insert into tttest values (2, 2, null);
  insert into tttest values (3, 3, 0);
  select * from tttest;
   price_id | price_val | price_on | price_off
  ----------+-----------+----------+-----------
!         1 |         1 |          |    999999
!         2 |         2 |          |    999999
!         3 |         3 |        0 |    999999
  (3 rows)

  delete from tttest where price_id = 2;
*+ ERROR:  ttdummy (tttest): price_on must be NOT NULL*
  select * from tttest;
   price_id | price_val | price_on | price_off
  ----------+-----------+----------+-----------
!         1 |         1 |          |    999999
!         2 |         2 |          |    999999
!         3 |         3 |        0 |    999999
  (3 rows)

  -- what do we see ?


Any suggestion would be appreciated...

Thank you for your help.
Regards,
Alexandra