============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Harry Waddell
Your email address : waddell@nas.nasa.gov
Category : runtime: back-end
Severity : non-critical
Summary: configure finds 8 byte int types, but int8 fails to work at runtime
System Configuration
--------------------
Operating System : sunos 5.6
PostgreSQL version : 6.5-990421
Compiler used : egcs 1.2
Hardware:
---------
SunOS sune1 5.6 Generic_105181-09 sun4u sparc SUNW,Ultra-Enterprise-10000
16 processors, 2GB memory
Versions of other tools:
------------------------
gmake, flex 2.5.4
--------------------------------------------------------------------------
Problem Description:
--------------------
support for the int8 datatype appears to be broken on
sunos 5.6, irix 6.5, and NetBSD 1.4Beta. configure finds the
appropriate long long types, alignment, and snprintf args
but int8 types overflow at runtime as if they were int4 types.
this problem also exists in v6.4.2 on netbsd 1.3.3.
--------------------------------------------------------------------------
Test Case:
----------
create table foo ( a int8 );
insert into foo values (100000000001);
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------