On Tue, Aug 5, 2008 at 2:08 PM, kaeptn haddock <[EMAIL PROTECTED]> wrote:
> 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.
pgAdmin does include the context line, if the server gives us one:
-- Executing query:
select foo();
ERROR: division by zero
CONTEXT: PL/pgSQL function "foo" line 4 at assignment
********** Error **********
ERROR: division by zero
SQL state: 22012
Context: PL/pgSQL function "foo" line 4 at assignment
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
