Re: Pg 7.2.3 int8 value out of range - Mailing list pgsql-bugs

Brian Macy <bmacy@macykids.net> writes:
> Only excepts 32bit values and not 64bit. Endian issue?
> This is on sparc linux.

Hmm, did configure find any working 64bit int type?  Let's see this part
of your src/include/pg_config.h file:


/* Set to 1 if type "long int" works and is 64 bits */
/* #undef HAVE_LONG_INT_64 */

/* Set to 1 if type "long long int" works and is 64 bits */
#define HAVE_LONG_LONG_INT_64

/* Set to 1 if type "long long int" constants should be suffixed by LL */
#define HAVE_LL_CONSTANTS 1

/* Define this as the appropriate snprintf format for 64-bit ints, if any */
#define INT64_FORMAT "%lld"


            regards, tom lane