Re: Postgres 7 on IRIX

Hernandez Alvarez Alfredo writes:
> Thanks. I tried making a link from the cc to
> /usr/freeware/bin/gcc... cant compile... I will try removing the mips
> compiler...

That won't help. Your problem is that configure has decided to use
the MIPSpro compiler and set the CFLAGS for that. gcc doesn't grok
them.

Try making another template file, e.g. template/irix6_gcc. Merge
template/irix5 and one or more of the _gcc templates. Then configure
with

./configure --with-template=irix6_gcc

For what it's worth I've just been building PostgreSQL 7.0.2 on IRIX
6.5.5m with the native MIPSpro 7.3 compilers. Both -n32 and -64
versions have been tried. -o32 is obsolescent and was not considered.

The -64 version gives 34 warnings about 64-bit pointers being stored
in 32-bit integers. That makes whatever is built unsafe IMHO. How
well does PostgreSQL build on Alpha and other 64-bit systems?

One worrying problem is that when optimized -O2 both -n32 and -64
versions failed regression tests such as oidjoins. An example is

SELECT oid, pg_aggregate.aggtransfn1
FROM pg_aggregate
WHERE pg_aggregate.aggtransfn1 != 0 AND
NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid =
pg_aggregate.aggtransfn1);
ERROR: getattproperties: no attribute tuple 1255 -2

I have not investigated further. Compiling without optimization seems
okay.

So the current state of affairs is that it is built -n32 -g and passes
the regression tests. To do this I've done the following.

1) Created a new template/irix6 containing