appendum:
If I add a WHERE to it, it works fine ... its only when I try to do
*everyone* that it screws up:
SELECT geo_distance(location::point,'(-79.412636,43.720768)'::point) FROM personal_data WHERE gid = 14215;
geo_distance
------------------337.832062731434
(1 row)
On Mon, 10 Jul 2000, The Hermit Hacker wrote:
>
> SELECT geo_distance(location::point,'(-79.412636,43.720768)'::point)
> FROM location_table;
>
> where location is defined as point already?
>
> I'm getting:
>
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
>
> each time ... its producing a core that I've yet to analyze,as I have to
> compile a new debugging server to do so. figured I'd check first that
> what I'm trying to do is possible, before I try and 'bark up the wrong
> tree' ...
>
> thanks ...
>
> Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
