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
