From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Value to long for type ....: Columnname missing |
Date: | 2012-04-16 07:52:39 |
Message-ID: | 20120416075239.GA14098@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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°
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Ernst | 2012-04-16 08:32:28 | Re: Recreate primary key without dropping foreign keys? |
Previous Message | Liam Caffrey | 2012-04-16 07:24:04 | Result sets from functions |