RedHat6.0 & Alpha - Mailing list pgsql-ports

From Uncle George
Subject RedHat6.0 & Alpha
Date
Msg-id 378C651A.720BE65F@voicenet.com
Whole thread Raw
In response to Port Bug Report: No primary key possible with type reltime & timestamp  (Unprivileged user <nobody>)
Responses Re: [PORTS] RedHat6.0 & Alpha
List pgsql-ports
Porting:
1)    Seems like -O0/-O1 works best for this machine. It appears u get
spin lock errors/timeouts if i optimize at -O3, and -O2

2) in nabstime.h, the typedefs AbsoluteTime & RelativeTime ( was that
Absolutetime & Relativetime ) should be kept at a fixed ( for all ports
) size like int32. Adjusting it to what ever size time_t becomes leads
to problems with 'signed' words v. 'non-signed' extended longwords. For
instance the constant 0x80000001 is a negative 32bit integer, but as a
time_t it just a large positive number!.

3) Having problems with sign extension also creates problems for '@ 3
seconds ago'::reltime.  see #2

4) You dont store reltime or abstime as 64bit's into the db. Are there
any plans to use 64bit  alpha/linux timevalues as reltime & abstime ?
maybe reltime64 & abstime64? whats the sql world doing with 'seconds
since 1970' if the year is > 2038 ( which is the 32bit signed overflow )
?

5) having $(CC) -mieee  all over just isn't good, particular if no float
operations are done.  It slows down everthing. Is there a way to limit
this in the makefile?
gat

BTW these are porting issues ( but as well  hacking issues ).


pgsql-ports by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [PORTS] Port Bug Report: No primary key possible with type reltime & timestamp
Next
From: Uncle George
Date:
Subject: Re: [PORTS] Port Bug Report: postmaster/linux kernel unaligned trap errors