Re: [GENERAL] reading cvs logs with pgadmin queries

Ok, I found the offending line. It was not the pgadmin line. There was a line with a large binary insert. Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Mon, Sep 23, 2013 at 6:31 PM, Adrian Klaver wrote: > On 09/23/2013 12:46 PM, Dave Cramer wrote: > >> OK, >> >> I have a

Re: [GENERAL] reading cvs logs with pgadmin queries

On 09/23/2013 12:46 PM, Dave Cramer wrote: OK, I have a little more information. Yes, in isolation I can import these lines, however something happens after 69000 lines. These lines cause an error. Is it the same error? The exact error message is ERROR: extra data after last expected column

Re: [GENERAL] reading cvs logs with pgadmin queries

I tried copying 500 lines above it and it still works :( Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Mon, Sep 23, 2013 at 4:15 PM, Alvaro Herrera wrote: > Dave Cramer escribió: > > OK, > > > > I have a little more information. > > > > Yes, in isolation I can import the

Re: [GENERAL] reading cvs logs with pgadmin queries

Dave Cramer escribió: > OK, > > I have a little more information. > > Yes, in isolation I can import these lines, however something happens after > 69000 lines. These lines cause an error. Stray quotes in previous lines? Perhaps check whether line 65999 was imported correctly. -- Álvaro Herre

Re: [GENERAL] reading cvs logs with pgadmin queries

OK, I have a little more information. Yes, in isolation I can import these lines, however something happens after 69000 lines. These lines cause an error. Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Fri, Sep 20, 2013 at 9:59 AM, Adrian Klaver wrote: > On 09/19/2013

Re: [GENERAL] reading cvs logs with pgadmin queries

On 09/19/2013 06:04 PM, Dave Cramer wrote: Adrian, 2) The exact error message is ERROR: extra data after last expected column considering ~39000 lines go in before this line I am fairly certain it is the line. New day, new start. I am not sure now that the line you showed is the probl

Re: [GENERAL] reading cvs logs with pgadmin queries

On 09/19/2013 06:04 PM, Dave Cramer wrote: Adrian, 1) yes I am using the example table 2) The exact error message is ERROR: extra data after last expected column considering ~39000 lines go in before this line I am fairly certain it is the line. I would tend to agree, I just can't se

Re: [GENERAL] reading cvs logs with pgadmin queries

Adrian, 1) yes I am using the example table CREATE TABLE postgres_log ( log_time timestamp(3) with time zone, user_name text, database_name text, process_id integer, connection_from text, session_id text, session_line_num bigint, command_tag text, session_start_time timestamp wi

Re: [GENERAL] reading cvs logs with pgadmin queries

On 09/19/2013 08:26 AM, Dave Cramer wrote: The errors are extra lines after with a query like this 2013-09-12 10:33:19.145 WST,"user","dbname",14581,"192.168.1.22:58840 ",523126d3.38f5,1,"SELECT",2013-09-12 10:28:35 WST,6/503023,0,ERROR,42P01,"relation ""dds_sto

Re: [GENERAL] reading cvs logs with pgadmin queries

The errors are extra lines after with a query like this 2013-09-12 10:33:19.145 WST,"user","dbname",14581,"192.168.1.22:58840",523126d3.38f5,1,"SELECT",2013-09-12 10:28:35 WST,6/503023,0,ERROR,42P01,"relation ""dds_stores"" does not exist",,"WITH RECURSIVE recursive_stores(id, name) AS (

Re: [GENERAL] reading cvs logs with pgadmin queries

On 09/19/2013 05:47 AM, Dave Cramer wrote: pgadmin uses multi line queries and copy from 'cvslogs' cannot read them. Does anyone have a work around or other solution ? It worked here for me: test=# INSERT INTO big_int_test VALUES (6.7); COPY postgres_log FROM '/usr/local/pgsql/da

[GENERAL] reading cvs logs with pgadmin queries

pgadmin uses multi line queries and copy from 'cvslogs' cannot read them. Does anyone have a work around or other solution ? Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca