Hi,
I recently had a similar problem (7.1.2) and I suspect you are suffering
the same. It turned out to (probably) be a compiler optimzation problem.
I could do
select int4(4::int8/4::int8);
and it would work on a machine compiled under gcc 2.95.2 but failed with
"int8 conversion to int4 is out of range" on a box comiled under 2.7.2.1.
My problem was with int84() and its offending code is almost identical to
dtoi4() which is this little piece of goods here.
if ((num < INT_MIN) || (num > INT_MAX))
elog(ERROR, "dtoi4: integer out of range");
If I were you I'd change this to
if (num < INT_MIN)
elog(ERROR, "dtoi4: integer out of range - too small");
if (num > INT_MAX)
elog(ERROR, "dtoi4: integer out of range - too big");
recompile and the (hopefully) watch the problem go away.
On Thu, 30 Aug 2001, Martin Weinberg wrote:
> I have a 7.1.2 system which gives the following error on any pg_dump:
>
> DumpComment: SELECT failed: 'ERROR: dtoi4: integer out of range
> '.
>
> This happens with any database. E.g. I made a very tiny database
> with a single table and two records and the same error and message
> is obtained.
Colin
