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

Started by Thomas Guettlerabout 14 years ago6 messagesgeneral
Jump to latest
#1Thomas Guettler
hv@tbz-pariv.de

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

#2Sergey Konoplev
gray.ru@gmail.com
In reply to: Thomas Guettler (#1)
Re: Value to long for type ....: Columnname missing

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

#3Guillaume Lelarge
guillaume@lelarge.info
In reply to: Sergey Konoplev (#2)
Re: Value to long for type ....: Columnname missing

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

#4Scott Marlowe
scott.marlowe@gmail.com
In reply to: Thomas Guettler (#1)
Re: Value to long for type ....: Columnname missing

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.

#5Thomas Guettler
hv@tbz-pariv.de
In reply to: Scott Marlowe (#4)
Re: Value to long for type ....: Columnname missing

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

#6Andreas Kretschmer
akretschmer@spamfence.net
In reply to: Thomas Guettler (#5)
Re: Value to long for type ....: Columnname missing

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�