Report: PostgreSQL 7.1RC4 works on SGI Irix 6.5

Hi,

I have managed to get PostgreSQL 7.1RC4 running on SGI Irix 6.5 without any
trouble.

A more complete report follows:
OS: IRIX64 ver 6.5
GNU make: 3.76.1
bison: 1.25
flex: 2.5.4 (are flex and bison even used anymore?)
tcl/tk: 8.0
perl: 5.6.0
GNU readline: 4.0

I used the native C and C++ compilers (see below for 'gcc'). I am using the -n32
ABI.

My confguration was setup to include the includes and libraries in /usr/local as
that is where I installed tcl/tk and the GNU packages.

> setenv CC /usr/bin/cc
> setenv CXX /usr/bin/CC
> ./configure \
> --prefix=/usr/local/pgsql \
> --with-includes=/usr/local/include \
> --with-libraries=/usr/local/lib \
> --with-CXX \
> --with-tcl \
> --with-tclconfig=/usr/local/lib \
> --with-tkconfig=/usr/local/lib \
> --with-perl \
> --enable-odbc

Running "gmake all" followed by "gmake check" leads to all tests passing (when
viewed by eye). Two tests failed when run by "diff".

The first failure was "final decimal digit" errors in the geometry test. I won't
bother showing any of those failures.

The second failure was during the "join" test. It is due to the ordering of the
returned tuples. I report them only because the README asks me to so that an
ORDER BY clause may be considered.

> *** ./expected/join.out Sat Jan 6 18:03:42 2001
> --- ./results/join.out Tue Apr 10 14:16:38 2001
> ***************
> *** 1731,1738 ****
> | 6 | 6 | six |
> | 7 | 7 | seven |
> | 8 | 8 | eight |
> - | | | null |
> | | 0 | zero |
> (13 rows)
>
> SELECT '' AS "xxx", *
> --- 1731,1738 ----
> | 6 | 6 | six |
> | 7 | 7 | seven |
> | 8 | 8 | eight |
> | | 0 | zero |
> + | | | null |
> (13 rows)
>
> SELECT '' AS "xxx", *
> ***************
> *** 1750,1757 ****
> | 6 | 6 | six |
> | 7 | 7 | seven |
> | 8 | 8 | eight |
> - | | | null |
> | | 0 | zero |
> (13 rows)
>
> SELECT '' AS "xxx", *
> --- 1750,1757 ----
> | 6 | 6 | six |
> | 7 | 7 | seven |
> | 8 | 8 | eight |
> | | 0 | zero |
> + | | | null |
> (13 rows)
>
> SELECT '' AS "xxx", *
> ***************
> *** 1799,1806 ****
> | 6 | 6 | six |
> | 7 | 7 | seven |
> | 8 | 8 | eight |
> - | | | null |
> | | 0 | zero |
> | | | |
> | | | | 0
> (15 rows)
> --- 1799,1806 ----
> | 6 | 6 | six |
> | 7 | 7 | seven |
> | 8 | 8 | eight |
> | | 0 | zero |
> + | | | null |
> | | | |
> | | | | 0
> (15 rows)
> ***************
> *** 1820,1827 ****
> | 6 | 6 | six |
> | 7 | 7 | seven |
> | 8 | 8 | eight |
> - | | | null |
> | | 0 | zero |
> | | | |
> | | | | 0
> (15 rows)
> --- 1820,1827 ----
> | 6 | 6 | six |
> | 7 | 7 | seven |
> | 8 | 8 | eight |
> | | 0 | zero |
> + | | | null |
> | | | |
> | | | | 0
> (15 rows)

=============================================================================
Back in January, Tom Lane asked if I (or anyone) could compile PostgreSQL on
Irix with gcc. I have finally gotten around to try and I have failed.

I am running gcc version 2.95.2

I alter the configure I list above so that 'gcc' and 'g++' are used instead of
'cc' and 'CC'. The compilation goes smoothly for a while and then bombs out with
some errors about undefined variables. I have not followed up on these, but I
have included the tail end of the 'gmake all' output in case anyone else wants
to have a look:

> /usr/local/bin/gcc -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -I/usr/local/include -U_NO_XOPEN4 -c freelist.c -o freelist.o
> /usr/local/bin/gcc -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -I/usr/local/include -U_NO_XOPEN4 -c localbuf.c -o localbuf.o
> /usr/local/bin/gcc -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -I/usr/local/include -U_NO_XOPEN4 -c s_lock.c -o s_lock.o
> s_lock.c: In function `s_lock':
> s_lock.c:134: warning: passing arg 1 of pointer to function discards qualifiers from pointer target type
> s_lock.c: At top level:
> s_lock.c:234: warning: `tas_dummy' defined but not used
> as: Error: /var/tmp/ccQWBkF9.s, line 421: undefined assembler operation: .global
> .global tas
> gmake[4]: *** [s_lock.o] Error 1
> gmake[4]: Leaving directory `/usr/cb-share/Src/PostgreSQL/postgresql-7.1rc4/src/backend/storage/buffer'
> gmake[3]: *** [buffer-recursive] Error 2
> gmake[3]: Leaving directory `/usr/cb-share/Src/PostgreSQL/postgresql-7.1rc4/src/backend/storage'
> gmake[2]: *** [storage-recursive] Error 2
> gmake[2]: Leaving directory `/usr/cb-share/Src/PostgreSQL/postgresql-7.1rc4/src/backend'
> gmake[1]: *** [all] Error 2
> gmake[1]: Leaving directory `/usr/cb-share/Src/PostgreSQL/postgresql-7.1rc4/src'
> gmake: *** [all] Error 2

I don't have a lot of time to work on this, but if someone has suggestions or
some patches to fix this, I'll try to compile it again with gcc.

Cheers,
Mark

--
Mark Dalphin email: mdalphin(at)amgen(dot)com
Mail Stop: 29-2-A phone: +1-805-447-4951 (work)
One Amgen Center Drive +1-805-375-0680 (home)
Thousand Oaks, CA 91320 fax: +1-805-499-9955 (work)