Re: psql freezes loading large file

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql freezes loading large file
Date: 2006-05-23 02:17:12
Message-ID: cone.1148350632.210295.39711.1000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ed Loehr 2006-05-23 03:19:52 Re: Why won't it index scan?
Previous Message Joshua D. Drake 2006-05-23 00:55:16 Re: Why won't it index scan?