Am 13.04.2012 20:35, schrieb Scott Marlowe:
On Thu, Apr 12, 2012 at 2:16 AM, Thomas Guettler<hv@xxxxxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
