Thread: Value to long for type ....: Columnname missing
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
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
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
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.
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
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°