RedHat6.0 & Alpha
От | Uncle George |
---|---|
Тема | RedHat6.0 & Alpha |
Дата | |
Msg-id | 378C651A.720BE65F@voicenet.com обсуждение исходный текст |
Ответ на | Port Bug Report: No primary key possible with type reltime & timestamp (Unprivileged user <nobody>) |
Ответы |
Re: [PORTS] RedHat6.0 & Alpha
|
Список | 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 по дате отправления: