Federico_Belotti
New member
Joined: 18 Jun 2010 10:41:25
Messages: 4
Offline
|
Dear All,
I've the same problem with postgreSQL 8.4. When I try to restore a .backup file created with pg_dump (by using the pg_restore procedure)
I get the error "Extra data after last expected column". I suspect that is a problem of encoding or delimiters. Can you help me?
here is the log:
2010-06-18 17:13:19 CEST ERROR: language "plpgsql" already exists
2010-06-18 17:13:19 CEST STATEMENT:
CREATE PROCEDURAL LANGUAGE plpgsql;
2010-06-18 17:24:26 CEST ERROR: extra data after last expected column
2010-06-18 17:24:26 CEST CONTEXT: COPY cart_accert, line 3084737: "\N N \N \N \N 0 785 \\N N \N \N \N41-21 100oRI\N \N 0 2952 MW67J@Y9[WER¶ 2000-01-25 2000-02-11 1..."
2010-06-18 17:24:26 CEST STATEMENT: COPY cart_accert (num_ese, ac_prn, ac_prezzo, ac_query, stampato, ac_out, ac_paga, ac_scad, ac_ripe, ac_code, ac_nt_code, ac_nt_fonte, ac_norma, ac_um, indotto, cod_ese, codificato, codice, data_open, data_upd, time_last, rowid, ora, userid, pb_code, ac_des, ac_val, ac_mem, ac_ese, ac_tipo, euro, rowid_master, ur_pb_id, data_richiesta, evidenza_referto, ritornato) FROM stdin;
2010-06-18 17:24:26 CEST LOG: could not send data to client: No connection could be made because the target machine actively refused it.
2010-06-18 17:24:26 CEST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.
2010-06-18 17:24:26 CEST LOG: incomplete message from client
Many thanks,
Federico
|