postgres error reporting - Mailing list pgsql-general

From chisel@herlpacker.co.uk (Chisel Wright)
Subject postgres error reporting
Date
Msg-id 2eeea331.0302170334.7c1acadf@posting.google.com
Whole thread Raw
Responses Re: postgres error reporting
List 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 by date:

Previous
From: Mikhail Majorov
Date:
Subject: Single-byte character set recoding
Next
From: "Веретенников Алексей"
Date:
Subject: continuous data from stdin