Re: find close (duplicate) points + create index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Elinor <elinor(at)wise1(dot)tau(dot)ac(dot)il>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: find close (duplicate) points + create index
Date: 2005-02-16 20:08:48
Message-ID: 26863.1108584528@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Elinor <elinor(at)wise1(dot)tau(dot)ac(dot)il> writes:
> After many many minutes, it started giving these lines:
> server sent data ("D" message) without prior row description
> ("T" message)

Up till fairly recently (8.0 or maybe 7.4), libpq would do that if it
ran out of memory to hold the query result. I think you miswrote the
query and it's returning a huge number of rows. If you actually want
to fetch a huge number of rows, try using a cursor ...

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Christopher Browne 2005-02-16 23:02:55 Re: Front End Languages for PostgreSQL
Previous Message Van Ingen, Lane 2005-02-16 20:07:47 Front End Languages for PostgreSQL