Re: PostgreSQL 7.4beta3 does not compile on AIX 5 ...

Tom Lane wrote:
>>we have fixed the first problem.
>>here is the next one ...
>>libm seems to be missing although it is installed (I have installed it 
>>for running 7.3.4).
> It looks like -lm needs to be added to SHLIB_LINK in ecpglib/Makefile.> I had already proposed this patch for
SSL-enabledbuilds:>> *** src/interfaces/ecpg/ecpglib/Makefile.orig    Fri Aug  1 12:46:18 2003> ---
src/interfaces/ecpg/ecpglib/Makefile   Tue Sep 16 01:29:43 2003> ***************> *** 21,27 ****>   OBJS= execute.o
typename.odescriptor.o data.o error.o prepare.o 
 
memory.o \>       connect.o misc.o>> ! SHLIB_LINK = -L../pgtypeslib -lpgtypes $(libpq) $(THREAD_LIBS)>>   all:
all-lib>>--- 21,27 ---->   OBJS= execute.o typename.o descriptor.o data.o error.o prepare.o 
 
memory.o \>       connect.o misc.o>> ! SHLIB_LINK = -L../pgtypeslib -lpgtypes $(libpq) $(filter -lssl, 
$(LIBS)) $(THREAD_LIBS)>>   all: all-lib>> and based on your report I guess it actually needs to be "filter 
-lssl -lm".> Please try it?>>             regards, tom lane




i have applied the patch below.
i have added -lm to ecpglib/Makefile
in addition to that i had to add

-lm -L../../libpq -lpq

to compatlib/Makefile

now it seems to compile properly.
can anybody verify that?


regression test on RS/6000 (2 x 375 Mhz), AIX 5.1; GCC 2.95:

gmake[3]: Leaving directory 
`/usr/src/shopnet/postgresql-7.4beta3/contrib/spi'
/bin/sh ./pg_regress --temp-install --top-builddir=../../.. 
--schedule=./parallel_schedule --multibyte=SQL_ASCII
============== removing existing temp installation    ==============
============== creating temporary installation        ==============
============== initializing database system           ==============
============== starting postmaster                    ==============
running on port 65432 with pid 17596
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
============== dropping regression test user accounts ==============
============== installing PL/pgSQL                    ==============
============== running regression test queries        ==============
parallel group (13 tests):  int2 int4 text name int8 boolean float4 oid 
char float8 varchar bit numeric     boolean              ... ok     char                 ... ok     name
... ok     varchar              ... ok     text                 ... ok     int2                 ... ok     int4
       ... ok     int8                 ... ok     oid                  ... ok     float4               ... ok
float8              ... ok     bit                  ... ok     numeric              ... ok
 
test strings              ... ok
test numerology           ... ok
parallel group (20 tests):  point comments path reltime date interval 
lseg abstime time tinterval polygon circle timetz box inet timestamptz 
timestamp type_sanity oidjoins opr_sanity     point                ... ok     lseg                 ... ok     box
          ... ok     path                 ... ok     polygon              ... ok     circle               ... ok
date                ... ok     time                 ... ok     timetz               ... ok     timestamp            ...
ok    timestamptz          ... ok     interval             ... ok     abstime              ... ok     reltime
  ... ok     tinterval            ... ok     inet                 ... ok     comments             ... ok     oidjoins
         ... ok     type_sanity          ... ok     opr_sanity           ... ok
 
test geometry             ... ok
test horology             ... ok
test insert               ... ok
test create_function_1    ... ok
test create_type          ... ok
test create_table         ... ok
test create_function_2    ... ok
test copy                 ... ok
parallel group (7 tests):  create_aggregate create_operator vacuum 
triggers inherit constraints create_misc     constraints          ... ok     triggers             ... ok
create_misc         ... ok     create_aggregate     ... ok     create_operator      ... ok     inherit              ...
ok    vacuum               ... ok
 
parallel group (2 tests):  create_view create_index     create_index         ... ok     create_view          ... ok
test sanity_check         ... ok
test errors               ... ok
test select               ... ok
parallel group (17 tests):  select_distinct_on select_into 
select_distinct transactions update aggregates select_having case random 
subselect union select_implicit hash_index btree_index arrays portals join     select_into          ... ok
select_distinct     ... ok     select_distinct_on   ... ok     select_implicit      ... ok     select_having        ...
ok    subselect            ... ok     union                ... ok     case                 ... ok     join
  ... ok     aggregates           ... ok     transactions         ... ok     random               ... failed (ignored)
  portals              ... ok     arrays               ... ok     btree_index          ... ok     hash_index
...ok     update               ... ok
 
test privileges           ... ok
test misc                 ... ok
parallel group (5 tests):  portals_p2 select_views cluster rules foreign_key     select_views         ... ok
portals_p2          ... ok     rules                ... ok     foreign_key          ... ok     cluster              ...
ok
parallel group (14 tests):  limit copy2 sequence temp polymorphism 
truncate prepare conversion stats rangefuncs without_oid domain plpgsql 
alter_table     limit                ... ok     plpgsql              ... ok     copy2                ... ok     temp
            ... ok     domain               ... ok     rangefuncs           ... ok     prepare              ... ok
without_oid         ... ok     conversion           ... ok     truncate             ... ok     alter_table          ...
ok    sequence             ... ok     polymorphism         ... ok     stats                ... ok
 
============== shutting down postmaster               ==============

================================================== 92 of 93 tests passed, 1 failed test(s) ignored.
==================================================

The differences that caused some tests to fail can be viewed in the
file `./regression.diffs'.  A copy of the test summary that you see
above is saved in the file `./regression.out'.

gmake[2]: Leaving directory 
`/usr/src/shopnet/postgresql-7.4beta3/src/test/regress'
gmake[1]: Leaving directory `/usr/src/shopnet/postgresql-7.4beta3/src/test'




-- 
Cybertec Geschwinde u Schoenig
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/2952/30706; +43/660/816 40 77
www.cybertec.at, www.postgresql.at, kernel.cybertec.at