Re: Which tool versions yield working pgsql on SunOS 4.1.4 ?

warren_spencer_1977@yahoo.com (Warren Spencer) writes:
> I'm attempting to install PostgreSQL on a SunOS 4.1.4 box.  So far,
> I've tried various combinations of gcc 2.95.1,.2,.3, PostgreSQL 7.1.3,
> 7.0.3, 7.3.  In some cases, gcc won't build. In others, PostgreSQL
> won't build.  But in the gcc 2.95.2/pg 7.1.3 case, I've got exactly
> the same INITDB problem as Jeff Stevens (post 2002-09-25 09:36:36
> PST):  ERROR:  syntax error at line 2658: unexpected token parse
> error.

What awk are you using?  Jeff's problem appeared to stem from using an
awk that didn't recognize the ENVIRON["foo"] construct; at any rate
something was going wrong with genbki.sh's attempt to initialize
"nextbkioid" in its main awk run.  I suppose the problem might also be
somewhere in this fragment of that script:

# Get FirstGenBKIObjectId from access/transam.h
for dir in $INCLUDE_DIRS; do
    if [ -f "$dir/access/transam.h" ]; then
        BKIOBJECTID=`grep '^#define[     ]*FirstGenBKIObjectId' $dir/access/transam.h | $AWK '{ print $3 }'`
        break
    fi
done
export BKIOBJECTID

Anyway, play around with src/backend/catalog/genbki.sh to see if you can
see what's going on.  Correct initialization of pg_aggregate should look
like

open pg_aggregate
insert OID = 10000 ( avg 1 int8_accum numeric_avg 20 1231 1700 "{0,0,0}" )
insert OID = 10001 ( avg 1 int4_avg_accum int8_avg 23 1016 1700 "{0,0}" )
insert OID = 10002 ( avg 1 int2_avg_accum int8_avg 21 1016 1700 "{0,0}" )
...

but Jeff's output looked like

open pg_aggregate
insert OID = ( avg 1 int8_accum numeric_avg 20 1231 1700 "{0,0,0}" )
insert OID = 1 ( avg 1 int4_avg_accum int8_avg 23 1016 1700 "{0,0}" )
insert OID = 2 ( avg 1 int2_avg_accum int8_avg 21 1016 1700 "{0,0}" )
...


BTW, if you get it going with PG 7.3, please let us know.  SunOS used to
be considered a supported platform, but we've not heard any reports from
users of it in quite awhile ...

            regards, tom lane