Home > Archive > PostgreSQL Bugs > May 2005 > BUG #1690: Problem with COPY command









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author BUG #1690: Problem with COPY command
Ralph Moser

2005-05-31, 9:24 am


The following bug has been logged online:

Bug reference: 1690
Logged by: Ralph Moser
Email address: ralph.moser@aon.at
PostgreSQL version: 8.0.2
Operating system: Windows XP Pro / Linux
Description: Problem with COPY command
Details:

Hi!

If i dump a SQL_ASCII database and then try to restore it i get the
following message:

pg_restore: ERROR: extra data after last expected column
KONTEXT: COPY settings, line 50: "menuemsg Hauptmenü
nemno Nein, zurück ins Hauptmenü
nemyes Ja, einen Schritt zurück"
pg_restore: [Archivierer (DB)] Fehler in PQendcopy

But if i choose the "With insert commands" option the error doesn't occour.
I think this is an error in the COPY command. It interprets an umlaut as a
field seperator.
My problem is that i can't backup OIDs if i use my workaround.

Yours sincerly
Ralph Moser

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

http://archives.postgresql.org

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com