Re: Installation Report for powerpc-apple-netbsdelf1.5

I just had a go on NetBSD-1.5C/i386 with a fresh cvs - first time since the
new autoconf stuff..

On Wed, Jul 26, 2000 at 04:02:33AM +0000, Thomas Lockhart wrote:
> > First problem:  ODBC doesn't compile.  |-(

I didn't try to compile odbc..

> > Second problem:  with elf binaries the location of shared libraries
> > is supposed to be compiled in so each program can reference its own
> > set of shared objects without conflict.  This doesn't seem to jibe
> > with how the build/install makefiles do things.  I get missing shared
> > libraries when I try to access the DB as a normal user, and the
> > mechanism I would have used to fix this on an xcoff system is
> > deleted, or at least deprecated, on an elf system.
> 
> There was some discussion recently about whether -rpath is A Good Thing,
> with Debian voting that it is One Step From Hell. I've always just
> modified my ld.config and/or my LD_LIBRARY_PATH environment to get to
> the libraries.
> 
> Either of these should solve your regression test problem.

As it happens my LD_LIBRARY_PATH is always empty and there is no ldconfig on
my system, the standard ld.so.conf file on i386 (elf) being
libm.so.0       machdep.fpu_present     1:libm387.so.0,libm.so.0

So, any chance of putting -rpath in? Without it you end up with:

% ldd psql
psql:
         -lpq.2 => not found
         -lz.0 => /usr/lib/libz.so.0
         -lcrypt.0 => /usr/lib/libcrypt.so.0
         -lm.0 => /usr/lib/libm387.so.0
         -lm.0 => /usr/lib/libm.so.0
         -lutil.5 => /usr/lib/libutil.so.5
         -ltermcap.0 => /usr/lib/libtermcap.so.0
         -lcurses.3 => /usr/lib/libcurses.so.3
         -lc.12 => /usr/lib/libc.so.12

Then I need to relink psql with -Wl,-R/usr/local/pgsql/lib ...

> > Third problem:  well actually the regression tests seem to work, mostly.  ;-)

Where they the parallel regression tests? Does "unlimit maxproc" help? (I
usually forget to do this and maxproc=80 isn't enough for me)
All the tests bar geometry work for me, but the latter has:

--- results/geometry.out        Wed Jul 26 16:01:12 2000
***************
*** 294,307 ****
  (8 rows)
  
  SELECT '' AS four, path(f1) FROM POLYGON_TBL;
!  four |        path         
! ------+---------------------
!       | ((2,0),(2,4),(0,0))
!       | ((3,1),(3,3),(1,0))
!       | ((0,0))
!       | ((0,1),(0,1))
! (4 rows)
! 
  -- translation
  SELECT '' AS eight, p1.f1 + point '(10,10)' AS dist_add
     FROM PATH_TBL p1;
--- 294,300 ----
  (8 rows)
  
  SELECT '' AS four, path(f1) FROM POLYGON_TBL;
! ERROR:  parser: parse error at or near "("
  -- translation
  SELECT '' AS eight, p1.f1 + point '(10,10)' AS dist_add
     FROM PATH_TBL p1;
***************


in amongst the rounding errors..

Cheers,

Patrick