Bug/Feature Request: pgAdmin should show "context" part of error message for problems with COPY command - Mailing list pgadmin-support

From kaeptn haddock
Subject Bug/Feature Request: pgAdmin should show "context" part of error message for problems with COPY command
Date
Msg-id 1217941698.14758.9.camel@heidi
Whole thread Raw
Responses Re: Bug/Feature Request: pgAdmin should show "context" part of error message for problems with COPY command  ("Dave Page" <dpage@pgadmin.org>)
List 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



pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Google Summer of Code Projects
Next
From: "Dave Page"
Date:
Subject: Re: Bug/Feature Request: pgAdmin should show "context" part of error message for problems with COPY command