Re: Syntax error in a large COPY

Поиск
Список
Период
Сортировка
От Reg Me Please
Тема Re: Syntax error in a large COPY
Дата
Msg-id 200711071051.10173.regmeplease@gmail.com
обсуждение исходный текст
Ответ на Re: Syntax error in a large COPY  (Reg Me Please <regmeplease@gmail.com>)
Ответы Re: Syntax error in a large COPY
Список pgsql-general
Il Wednesday 07 November 2007 07:54:41 Reg Me Please ha scritto:
> Il Wednesday 07 November 2007 01:29:44 Alvaro Herrera ha scritto:
> > Reg Me Please wrote:
> > > Il Tuesday 06 November 2007 22:13:15 hai scritto:
> > > That's the "branch and bound". Editing 29M+ lines file takes some time.
> > > But this is the way I'm going to go right now.
> >
> > Huh, why not just use pgloader?
>
> Becasue I never heard about it.
> Because it's not included into my distribution package list.
> And because I was trusting the "core tools" to work reasonably.
>
> I'll compile and use that.
>
> By the way, unsless you want to have logs at the debug level, no
> information has been found in the logs about the offending line(s)
> in the 29M+ COPY script.

pgloader seems not that easy to use for a newbie like myself.
Also because domentation seems too skinny.

In any case each "goto line, add lines, save, run" cycle requires about 10
minutes on my PC. And the logs don't provide any useful detail.
So, again, better logging would help in any case.

--
Reg me Please

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

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: RE: [GENERAL] ‘--pwfile’ command
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Syntax error in a large COPY