Re: Error restoring bytea from dump

Hi again,

Another mistake of mine ... :) The real problem was that I used a Windows
based archiver (PowerArchiver) to unzip the gz file which - for some reasons
??? - chunked the long lines at aproximately every 16K. Using gunzip the
problem oozed away. :)

Bye,
-- Csaba

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Michael Fuhr
Sent: Tuesday, October 26, 2004 10:05 PM
To: Egy?d Csaba (Freemail)
Cc: 'Pgsql-General(at)Postgresql(dot)Org'
Subject: Re: [GENERAL] Error restoring bytea from dump

On Tue, Oct 26, 2004 at 08:51:31PM +0200, Együd Csaba wrote:
>
> the restoration of a dump stops at the line above.

What line above? Are you referring to "Error restoring bytea" in the
subject header? Is that the *exact* error message?

> The dump was created with pgsql 7.3.2 and I need to pump it into a
> 7.4.3 one. Should anybody tell me what the problem can be and how I
> can solve it.

Have extraneous newlines and/or carriage returns made it into the dump?
That might result in "invalid input syntax for type bytea", which isn't the
exact error you mentioned but might be what you meant.

> (There are double apostophes [''] many times in the string - is it
normal???
> Besides of the field separator [','] of course...)

http://www.postgresql.org/docs/7.4/static/sql-syntax.html#SQL-SYNTAX-STRINGS
http://www.postgresql.org/docs/7.4/static/datatype-binary.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.778 / Virus Database: 525 - Release Date: 2004.10.15.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.778 / Virus Database: 525 - Release Date: 2004.10.15.