error:varchar too long - how to get details?

From: "Kacper Chrapa" <k(dot)chrapa(at)wp(dot)pl>
To: pgsql-general(at)postgresql(dot)org(dot)
Subject: error:varchar too long - how to get details?
Date: 2007-04-20 07:14:59
Message-ID: 462868734e609@wp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everyone !

I've got a little question :-)

When I try to insert too long string into some varchar(n) column,i get a
message like this:
ERROR:value too long for type character varying(10)

It's ok - but how can I get information,which column generates an error?
Is it possible ?

I don't see any hint or detail message(in psql) ,like in other cases (at
example, when i try to call
non existing function)...

Postgres version: 8.1

Best regards and thanks for help,
Kacper Chrapa

----------------------------------------------------
Zespół Yamato - posłuchaj jak grają na bębnach
o średnicy 5 metrów! Już wkrótce ich trasa w Polsce.
Zobacz: http://klik.wp.pl/?adr=http%3A%2F%2Fadv.reklama.wp.pl%2Fas%2Fyamato.html&sid=1107

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Toth 2007-04-20 07:42:58 Re: Download source
Previous Message Peter Eisentraut 2007-04-20 06:30:08 Re: Unexplained case insensitive results