General Bug Report: configure finds 8 byte int types, but int8 fails to work at runtime - Mailing list pgsql-bugs

From Unprivileged user
Subject General Bug Report: configure finds 8 byte int types, but int8 fails to work at runtime
Date
Msg-id 199904230022.UAA38162@hub.org
Whole thread Raw
List pgsql-bugs
============================================================================
                        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:
---------


--------------------------------------------------------------------------


pgsql-bugs by date:

Previous
From: "Mike Erickson"
Date:
Subject: int8 & primary key error
Next
From: jarausch@numa1.igpm.rwth-aachen.de (Helmut Jarausch)
Date:
Subject: Patches for IRIX 6.5.3 (current snapshot)