Hello dear developers,

I wrote a function for the server, that rises this error when called
(called and displayed in PGAdmin III):

ERROR: value too long for type character varying(255)
SQL Status:22001
Kontext:PL/pgSQL function "fkt_calculateshoppinglistitems" line 26
at assignment
PL/pgSQL function "fkt_calculateallshoppinglistitems" line 16 at FOR
over SELECT rows

When this function is called by JDBC, the only information stored in the
exception is:

ERROR: value too long for type character varying(255)

Which makes debugging from server logfiles much harder. I expected to
have some more exceptions encapsulated (retrievable with
getNextException on PSQLException), but found nothing.

Where do I have to look for the missing information?

With best regards,
Daniel Migowski

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc