Re: find close (duplicate) points + create index

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Elinor <elinor@wise1.tau.ac.il>
Cc: pgsql-novice@postgresql.org
Date: 2005-02-16T20:08:48Z
Lists: pgsql-novice
Elinor <elinor@wise1.tau.ac.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