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

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();
                                                     version
----------------------------------------------------------------------------------------------------------------
  PostgreSQL 9.1.3 on x86_64-pc-linux-gnu, compiled by gcc-4.6.real (Ubuntu/Linaro 4.6.1-9ubuntu3) 4.6.1, 64-bit
(1 row)


--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de