Re: Cannot import logs from csv - Mailing list pgsql-general

From Helen Griffiths
Subject Re: Cannot import logs from csv
Date
Msg-id alpine.LFD.2.03.1310181822470.8095@dur.ac.uk
Whole thread Raw
In response to Re: Cannot import logs from csv  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Cannot import logs from csv
Re: Cannot import logs from csv
List pgsql-general
On Fri, 18 Oct 2013, Adrian Klaver wrote:

> This came up before recently in this thread:
>
> http://www.postgresql.org/message-id/CADK3HHJNEWKD9gNyXmjv9ABbn+37rY3Mvp9=1j7msg9YpoBBBw@mail.gmail.com
>
> To cut to the chase, in that case the OP found:
>
> "Ok, I found the offending line. It was not the pgadmin line. There was a
> line with a large binary insert."
>
> Not sure if that helps.

It might: there are then some lines like:
2013-10-11 02:44:26.164
BST,"postgres","course_records",19216,"[local]",525740b3.4b10,124887,"idle
in transaction",2013-10-11 01:05:07 BST,7/16388,0,LOG,00000,"fastpath
function call: ""loread"" (OID 954)",,,,,,,,

I suspect the ""loread"" is the offender.

Thanks to all for the help.  I would never have thought to suspect the
lines after the one given in the error message.

--
Helen Griffiths


pgsql-general by date:

Previous
From: Amit Langote
Date:
Subject: Links in docs broken
Next
From: Rémi Cura
Date:
Subject: Re: Cannot import logs from csv