postgres error reporting
От | chisel@herlpacker.co.uk (Chisel Wright) |
---|---|
Тема | postgres error reporting |
Дата | |
Msg-id | 2eeea331.0302170334.7c1acadf@posting.google.com обсуждение исходный текст |
Ответы |
Re: postgres error reporting
|
Список | pgsql-general |
I like postgres, I find I get on much better with it than mysql. I have one really big problem with it though. Why is the error reporting so bad/vague for failed inserts? I have a perl script that's doing an insert query with 45-50 fields. There seems to be some bad data in the file I'm importing from. The message from postgres: DBD::Pg::db do failed: ERROR: pg_atoi: zero-length string at /path/to/Module.pm line 348, <STDIN> line 1. Which field doesn't it like?! Why can't it say something like: DBD::Pg::db do failed: ERROR: pg_atoi: zero-length string in field SomeTableField .... Is there something I'm missing that will give me this information? It's nothing to do with the perl either. Pasting the query into psql gives: ERROR: pg_atoi: zero-length string No clues as to which field or piece of data it is complaining about. Does anyone know how to find this out? Chisel
В списке pgsql-general по дате отправления: