The following bug has been logged online: Bug reference: 1050 Logged by: Taku YASUI
Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Debian GNU/Linux Description: cannot restore db at postgresql 7.4.1 Details: I tried to upgrade postgresql from 7.1.2(other host) to 7.4.1(localhost). However an error occured and failed restore. I tried following steps. % pg_dump --version pg_dump (PostgreSQL) 7.4.1 % pg_dump -b -Fc -h host -U user dbname -f dbname.dump % pg_restore -v -d dbname dbname.dump : pg_restore: restoring data for table "table_name" pg_restore: ERROR: invalid input syntax for integer: " " CONTEXT: COPY table_name, line 2, column column_name: " " pg_restore: [archiver (db)] error returned by PQendcopy pg_restore: *** aborted because of error This error does not occur 7.3.4. I found a modification from 7.3 to 7.4 to cause this problem. The release notes of 7.4 saids: COPY now can process files that use carriage-return or carriage-return/line-feed end-of-line sequences. Literal carriage-returns and line-feeds are no longer accepted in data values; use \r and \n instead. When I tried to use '-d' option to run pg_dump, pg_restore completed. Therefore, I think this modification causes the problem. I think this is bug and pg_dump/pg_restore should be fixed to keep with this modification. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
