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

From: Thomas Guettler <hv(at)tbz-pariv(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Value to long for type ....: Columnname missing
Date: 2012-04-16 07:23:10
Message-ID: 4F8BC8DE.8070101@tbz-pariv.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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();
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Liam Caffrey 2012-04-16 07:24:04 Result sets from functions
Previous Message Frank Lanitz 2012-04-16 04:57:17 Re: Recreate primary key without dropping foreign keys?