Re: psql freezes loading large file - Mailing list pgsql-general

From Francisco Reyes
Subject Re: psql freezes loading large file
Date
Msg-id cone.1148350632.210295.39711.1000@zoraida.natserv.net
Whole thread Raw
In response to psql freezes loading large file  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-general
Tom Lane writes:

> I don't have the patience to run this for 10^8 rows, but the test case

I got suspicious of my 'test' file so I took 1000 rows. That had problems
and pointed out problems with the file.

It seems I had mismatched single quotes.. my guess is that psql got confused
and went into into an infinite loop somewhow. With the 1000 rows sample it
reported the error. I am re-doing the input file.



pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Why won't it index scan?
Next
From: "Greg"
Date:
Subject: Re: Installing PostGreSQL automatically