Detailed error message information

From: Jurgen Defurne <jurgen(dot)defurne(at)pandora(dot)be>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Detailed error message information
Date: 2003-09-05 17:05:45
Message-ID: 20030905170545.GA1158@gallia
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,

Is there a way to obtain more information about error messages, eg. the
name of the column which generates an error ?

I find it problematic that when some operations cause an error, there is
no feedback about the complete error, eg. when I do an INSERT into a
field, which exceeds the fields length, the only thing I get is

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

No fieldname present.

When I put a string into a number field, I get

ERROR: pg_atoi: error in "string": can't parse "string"

Also, no fieldname present.

Of course, these are things that can be catched before the insert, but
when prototyping code and user interfaces, it is not always obvious
where a certain error comes from.

Any comments ?

Regards,

Jurgen

Browse pgsql-general by date

  From Date Subject
Next Message Zengfa Gao 2003-09-05 17:06:50 Left join
Previous Message psql-mail 2003-09-05 16:43:40 Re: postmaster crashing