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

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

From
Thomas Guettler
Date:
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?

How can you report feature request?

   Thomas Güttler



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

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

From
Sergey Konoplev
Date:
On Thu, Apr 12, 2012 at 12:16 PM, Thomas Guettler <hv@tbz-pariv.de> wrote:
> How can you report feature request?

You can submit it here http://www.postgresql.org/support/submitbug/

>
>  Thomas Güttler
>
>
>
> --
> Thomas Guettler, http://www.thomas-guettler.de/
> E-Mail: guettli (*) thomas-guettler + de
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general



--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com
LinkedIn: http://ru.linkedin.com/in/grayhemp
JID/GTalk: gray.ru@gmail.com Skype: gray-hemp

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

From
Guillaume Lelarge
Date:
On Fri, 2012-04-13 at 17:19 +0400, Sergey Konoplev wrote:
> On Thu, Apr 12, 2012 at 12:16 PM, Thomas Guettler <hv@tbz-pariv.de> wrote:
> > How can you report feature request?
>
> You can submit it here http://www.postgresql.org/support/submitbug/
>

No, this allows you to report a bug, not a feature request.


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com


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

From
Scott Marlowe
Date:
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.

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

From
Thomas Guettler
Date:
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

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

From
Andreas Kretschmer
Date:
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°