Thomas Chille <[EMAIL PROTECTED]> writes: > I dumped from a 7.3.4 server on debian with kernel 2.6 using this command: > pg_dump -F c -Z 9 -f backoffice.dmp.c backoffice > I tried to restore on a similiar system using: > pg_restore -vd backoffice backoffice.dmp.c > and stepped into an error: > ERROR: copy: line 270892, Missing data for column "id_tax"
Try asking pg_restore to dump to a text file (maybe dump just this one table) and look at the data to see if you can tell what happened to it. Note the line number is within the copy data, ie, the first data line after the COPY command is line 1. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly