Skip site navigation (1) Skip section navigation (2)

Re: Using nulls with earthdistance operator crashes backend

From: Mark Stosberg <mark(at)summersault(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Using nulls with earthdistance operator crashes backend
Date: 2001-07-31 17:03:02
Message-ID: 3B66E4B7.68D6B596@summersault.com (view raw or flat)
Thread:
Lists: pgsql-bugs
I'll give it a shot and post the patch or let you know I'm stuck. :) Thanks!

  -mark 

Tom Lane wrote:
> 
> Mark Stosberg <mark(at)summersault(dot)com> writes:
> > * Install earthdistance operator from the contrib directory.
> > * try this:
> > cascade=> select null <@> '1,1'::point;
> 
> > ## The result I get:
> > pqReadData() -- backend closed the channel unexpectedly.
> 
> Probably the earthdistance functions are not NULL-safe and need to be
> marked "isStrict" in CREATE FUNCTION.  Would you be willing to do the
> legwork on working up a patch for that?
> 
>                         regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

-- 

http://mark.stosberg.com/

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-07-31 18:43:51
Subject: Re: subquery results bypassed
Previous:From: Tom LaneDate: 2001-07-31 16:25:11
Subject: Re: Using nulls with earthdistance operator crashes backend

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group