BUG #1050: cannot restore db at postgresql 7.4.1

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1050: cannot restore db at postgresql 7.4.1
Date: 2004-01-15 04:29:46
Message-ID: 20040115042946.ADF8CCF48D2@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1050
Logged by: Taku YASUI

Email address: tach(at)valinux(dot)co(dot)jp

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-01-15 04:49:54 Re: BUG #1050: cannot restore db at postgresql 7.4.1
Previous Message Richard Huxton 2004-01-14 15:15:31 Re: BUG #1049: Invalid SQL Executed as JDBC Prepared Statement still executes embedded SQL