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 по дате отправления: