Re: BUG #7834: Overflow with limited information provided - Mailing list pgsql-bugs

From Pavan Deolasee
Subject Re: BUG #7834: Overflow with limited information provided
Date
Msg-id CABOikdMgrtP1_oO-_oESyEvY2SzZbPdd0=hZqGE_X6ozT2rTpA@mail.gmail.com
Whole thread Raw
In response to BUG #7834: Overflow with limited information provided  (jackie.qq.zhang@gmail.com)
List pgsql-bugs
On Tue, Jan 29, 2013 at 2:57 PM,  <jackie.qq.zhang@gmail.com> wrote:

>
> I wonder whether it's possible to print information like "what is the
> limited", "which configuration option is overflowed", etc. These infomation
> is of great help to users like me to fix the problem.
>

I think the error message gives a hint that the limit is the max value
that can be represented by size_t, which would most likely be 2^32 on
a 32-bit machine and 2^64 on a 64 machine. But I understand that it
might be a good idea to print the numeric value based on the known
value of size_t

The other part about what caused the overflow is a bit tricky because
even if the overflow got detected while adding size information for
some GUC, the real culprit might be something else and it will
difficult to find what caused the overflow. It would be a combination
of settings that will lead to this error. I guess you must be running
a 32-bit machine because causing this error on a 64-bit machine will
take some serious over-setting for a number of parameters.

Thanks,
Pavan


--
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee

pgsql-bugs by date:

Previous
From: Kurt Lidl
Date:
Subject: Re: BUG #7836: COPY command does not honor 'FORMAT' option
Next
From: Pavan Deolasee
Date:
Subject: Re: BUG #7827: Postgresql Porblem