Re: PostgreSQL 8.2 : regression failures on IA-64

Hi!

I think this was caused by a description mistake of "postgresql-test.patch".

> '/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regres/../../../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/regres/../../../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/regres/../../../contrib/spi/refint.so
Single quotes (') of end of line is insufficient.

> CREATE FUNCTION autoinc ()
> RETURNS trigger
> ! AS
> '/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regres/../../../contrib/spi/refint.so
We have to use "autoinc.so". (not "refint.so")

# And You had better fix "/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/" and
"/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regres/../../../contrib/spi/"
in "/usr/lib/pgsql/test/regress/".

best regards.

DANTE Alexandra wrote:
> Hello List,
>
> I have already posted an e-mail on the general mailing list but on the
> advice of Devrim Gunduz ;-) , I try on this mailing list.
> I try to generate the RPM from the src.rpm downloaded on the
> postgresql.org web site. I work on an IA-64 server with Red Hat
> Enterprise Linux 4 AS update 2.
> As root, the first command I launched was :
> [root(at)bt1 SOURCES]# rpm -i postgresql-8.2.0-2PGDG.src.rpm
> [root(at)bt1 SOURCES]# ls -ltr ../SPECS
> total 28
> -rw-r--r-- 1 root root 24840 Dec 5 06:04 postgresql-8.2.spec
> [root(at)bt1 SOURCES]# ls -ltr
> total 24176
> -rw-r--r-- 1 root root 12459207 Dec 2 20:25 postgresql-8.2.0.tar.bz2
> -rw-r--r-- 1 root root 897 Dec 2 20:28 pg_config.h
> -rw-r--r-- 1 root root 1539 Dec 2 20:28 Makefile.regress
> -rwxr-xr-x 1 root root 56 Dec 2 20:28 filter-requires-perl-Pg.sh
> -rw-r--r-- 1 root root 1631 Dec 2 20:28 postgresql-logging.patch
> -rw-r--r-- 1 root root 7529 Dec 2 20:28 postgresql.init
> -rw-r--r-- 1 root root 85 Dec 2 20:28 postgresql-bashprofile
> -rw-r--r-- 1 root root 1757 Dec 2 20:28 rpm-pgsql.patch
> -rw-r--r-- 1 root root 15598 Dec 2 20:28 README.rpm-dist
> -rw-r--r-- 1 root root 2563 Dec 2 20:28 postgresql-test.patch
> -rw-r--r-- 1 root root 919 Dec 2 20:28 postgresql-perl-rpath.patch
> -rw-r--r-- 1 root root 141 Dec 2 20:28 postgresql.pam
> -rw-r--r-- 1 root root 12198114 Dec 6 17:18
> postgresql-8.2.0-2PGDG.src.rpm
>
> Then from the SPECS directory, with the spec file that you can find
> attached, I launched as root :
> rpmbuild -ba postgresql-8.2.spec
>
> Then, as root, I changed the access to these directories :
> root# chmod -R a+w src/test/regress
> root# chmod -R a+w contrib/spi
>
> And as postgres, I launched the regression tests.
> root# su - postgres
> -bash-3.00$ gmake check
> The tests for create_function_1 and triggers fail...
> 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...
>
>
> You can find attach the files "regression.diff" and "regression.out"
> 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/regres/../../../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/regres/../../../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/regres/../../../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/regres/../../../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/regres/../../../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/regres/../../../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/regres/../../../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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--
kasahara(dot)tatsuhito(at)oss(dot)ntt(dot)co(dot)jp