BUG #1690: Problem with COPY command

Поиск
Список
Период
Сортировка
От Ralph Moser
Тема BUG #1690: Problem with COPY command
Дата
Msg-id 20050530100808.23AF3F0AC7@svr2.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #1678: pw_shadow BUS ERROR
Следующее
От: Abhijeet Gupta
Дата:
Сообщение: pg_dump.exe is failing with a fatal error