Noalyss

Code : Tout sélectionner

/usr/bin/pg_restore --port 5432 --username "laurent" --dbname "dossier26" --role "laurent" --no-password  --data-only --clean --single-transaction --no-data-for-failed-tables --table tmp_pcmn --schema public --verbose "/home/laurent/Téléchargements/pcmn asbl.bin"
pg_restore: connecting to database for restore
pg_restore: dropping TABLE DATA tmp_pcmn
pg_restore: processing data for table "tmp_pcmn"
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2476; 0 47822 TABLE DATA tmp_pcmn phpcompta
pg_restore: [archiver (db)] COPY failed for table "tmp_pcmn": ERROR:  function format_account(account_type) does not exist
LINE 1: SELECT format_account(NEW.pcm_val)
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  SELECT format_account(NEW.pcm_val)
CONTEXT:  PL/pgSQL function comptaproc.tmp_pcmn_alphanum_ins_upd() line 6 at assignment
COPY tmp_pcmn, line 1: "570001	Caisse 1	57	ACT"