Re: Value to long for type ....: Columnname missing

Thomas Guettler <hv(at)tbz-pariv(dot)de> wrote:

> Am 13.04.2012 20:35, schrieb Scott Marlowe:
>> On Thu, Apr 12, 2012 at 2:16 AM, Thomas Guettler<hv(at)tbz-pariv(dot)de> wrote:
>>> Hi,
>>>
>>> I think it would be very good, if postgresql reports which column is too
>>> small:
>>>
>>> Value to long for type character varying(1024) (message translated from
>>> german to english)
>>>
>>> Is there a reason not to report the column name?
>>
>> What version of pg are you using? I think later versions do report the column.
>
> 9.1.3
>
> postgres=# create table "foo" ("bar" varchar(1));
> CREATE TABLE
> postgres=# insert into foo values ('asdf');
> ERROR: value too long for type character varying(1)
> postgres=# select version();

Yeah, the same with 9.2dev, +1 for a feature request.

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°