-hackers pgsql-hackers@postgresql.org, Daniel Erez
de...@redhat.com
Sent: Monday, January 20, 2014 2:32:57 AM
Subject: Re: [HACKERS] Add value to error message when size extends
Hi Tom and Marti
Thank you so much for your respond.
The solution Tom proposed is much more better
Daniel Erez de...@redhat.com writes:
Many thanks for the prompt response and the suggestions!
So, regarding the issue of production quality you've mentioned,
we understand there are two remaining matters to address:
1. debug_query_string:
As we can't rely on this flag, is there any
Maor Lipchuk mlipc...@redhat.com writes:
We have encountered an issue when executing an insert command,
when one of the values' length was bigger than the column size limitation.
the error message which been displayed was value too long for type char...
but there was no indication which value
On Sun, Jan 19, 2014 at 8:10 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Complaining about a too-long varchar string in this style
seems practically guaranteed to violate that.
Agreed. But I think it would be useful to add the length of the string
being inserted; we already have it in the len
Marti Raudsepp ma...@juffo.org writes:
Agreed. But I think it would be useful to add the length of the string
being inserted; we already have it in the len variable.
Hm, maybe, but I'm having a hard time visualizing cases in which it
helps much.
regards, tom lane
--
Marti Raudsepp ma...@juffo.org writes:
On Sun, Jan 19, 2014 at 8:10 PM, Tom Lane t...@sss.pgh.pa.us wrote:
One thing that occurs to me just now is that perhaps we could report
the failure as if it were a syntax error
That would be cool, if it can be made to work.
Just as a five-minute
Hi Tom and Marti
Thank you so much for your respond.
The solution Tom proposed is much more better, and it will be a great
solution for clarifying many issues regarding this error.
Regards,
Maor
On 01/19/2014 10:00 PM, Tom Lane wrote:
Marti Raudsepp ma...@juffo.org writes:
On Sun, Jan 19,