Bug/Feature Request: pgAdmin should show "context" part of error message for problems with COPY command
| От | kaeptn haddock |
|---|---|
| Тема | Bug/Feature Request: pgAdmin should show "context" part of error message for problems with COPY command |
| Дата | |
| Msg-id | 1217941698.14758.9.camel@heidi обсуждение исходный текст |
| Ответы |
Re: Bug/Feature Request: pgAdmin should show "context" part of error message for problems with COPY command
|
| Список | 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 по дате отправления: