Re: Value to long for type ....: Columnname missing - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Value to long for type ....: Columnname missing
Date
Msg-id 20120416075239.GA14098@tux
Whole thread Raw
In response to Re: Value to long for type ....: Columnname missing  (Thomas Guettler <hv@tbz-pariv.de>)
List pgsql-general
Thomas Guettler <hv@tbz-pariv.de> wrote:

> Am 13.04.2012 20:35, schrieb Scott Marlowe:
>> On Thu, Apr 12, 2012 at 2:16 AM, Thomas Guettler<hv@tbz-pariv.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°

pgsql-general by date:

Previous
From: Thomas Guettler
Date:
Subject: Re: Value to long for type ....: Columnname missing
Next
From: Vincent Veyron
Date:
Subject: Re: Writing data to a text file based on a trigger event...