BUG #8880: no indication of value when exceeded maximum length

From: mlipchuk(at)redhat(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8880: no indication of value when exceeded maximum length
Date: 2014-01-19 16:11:39
Message-ID: 20140119161139.26703.79206@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8880
Logged by: Maor Lipchuk
Email address: mlipchuk(at)redhat(dot)com
PostgreSQL version: 9.2.3
Operating system: Fedora 18
Description:

When trying to insert a varchar value in a limited column which exceed the
column limitation, we get an error of "value too long for type
character(%d)).
e.g varchar(5) --> value of 6 character "123456"

There is no indication which value exceeded the limitation and for big
tables it is almost impossible to indicate the specific exceeded value.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Elein 2014-01-20 00:21:42 Re: BUG #7730: intarray representation of empty arrays
Previous Message Marko Tiikkaja 2014-01-19 00:50:01 Re: BUG #8870: PL/PgSQL, SELECT .. INTO and the number of result columns