Bug/Feature Request: pgAdmin should show "context" part of error message for problems with COPY command

From: kaeptn haddock <kaeptn(dot)haddock(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Bug/Feature Request: pgAdmin should show "context" part of error message for problems with COPY command
Date: 2008-08-05 13:08:18
Message-ID: 1217941698.14758.9.camel@heidi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

When issueing a COPY command like this one

--------------------
COPY tablename FROM '/var/www/hdberat.tab' WITH NULL AS '';
--------------------

The error-message in pgadminIII is quite short

********** Error ***********************************************
FEHLER: fehlende Daten für Spalte »termin_dauer_eingabe«
SQL state: 22P04
-----------------------------------------------------------------

(For those who don't understand German: it says: missing data for column
xy). In PHP-pgadmin the errormessage is much more meaningful, because it
adds the CONTEXT-line, where it actually tells me the number of the line
("Zeile") in the source-file, where the error occurred:

****************************************************************
FEHLER: fehlende Daten für Spalte »termin_dauer_eingabe«
CONTEXT: COPY fm_hdberat, Zeile 10421: »admin1 Gründler Pius archiviert "Texteingabe" "Texteingabe" "Texteingabe" "Texteingabe" "Textein...«
-------------------------------------------------------------------

It'd be a big help, if pgadmin was as verbose as php-pgadmin.
Best regards
pl

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2008-08-06 13:46:06 Re: Bug/Feature Request: pgAdmin should show "context" part of error message for problems with COPY command
Previous Message Guillaume Lelarge 2008-08-01 08:29:34 Re: Google Summer of Code Projects