Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Tue, 05 Aug 2008 15:08:18 +0200
  • Message-id: <1217941698.14758.9.camel@heidi> <text/plain>

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




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group