By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,372 Members | 1,950 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,372 IT Pros & Developers. It's quick & easy.

Detailed error message information

P: n/a
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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 11 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.