Re: PostgreSQL 8.2 : regression failures on IA-64

Thank you very much : it works !!!!
-bash-3.00$ gmake check 2>&1 |tee traces_check8.2.0_gcc_121206_v2.log
... ... ...
test create_function_1    ... ok
triggers             ... ok
... ... ...
=======================All 103 tests passed.
=======================

The problems were those you found :
- I replaced AS '@abs_spidir@/refint@DLSUFFIX@' by AS 
'@abs_spidir@/autoinc@DLSUFFIX@'
- I added ' at lines 58, 63, 68

By doing this, the regression tests are OK !
Regards,
Alexandra

Tatsuhito Kasahara wrote:

> 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@bt1 SOURCES]# rpm -i postgresql-8.2.0-2PGDG.src.rpm
>> [root@bt1 SOURCES]# ls -ltr ../SPECS
>> total 28
>> -rw-r--r--  1 root root 24840 Dec  5 06:04 postgresql-8.2.spec
>> [root@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
>>
>
>