[postgis-users] Error when getting geometry as binary

Paul Ramsey pramsey at refractions.net
Sun Feb 6 20:43:47 PST 2005


Well, I think it is still a valid bug, but you are trying to make WKB 
out of a bbox (the return from extent) and there is no such thing as a 
WKB bbox. So things should fail a little more gracefully. The 
envelope() trick turns the bbox into a polygon, for which there is a 
WKB form.

P.

On 6-Feb-05, at 7:09 PM, Abe Gillespie wrote:

> That succeeds fine.  Know what the problem is then?
>
> -Abe
>
> On Feb 6, 2005, at 8:09 PM, Paul Ramsey wrote:
>
>> What happens if you do asbinary(envelope(extent(the_geom)))?
>>
>> On 6-Feb-05, at 4:59 PM, Abe Gillespie wrote:
>>
>>> This statement works fine:
>>> SELECT extent(the_geom) from shape_table
>>>
>>> But this statement:
>>> SELECT asBinary(extent(the_geom)) from shape_table
>>> results in:
>>> ERROR:  invalid memory alloc request size 1074393504
>>>
>>> I'm running PostgreSQL 7.4.1 / PostGIS 0.9.1 on a Debian Linux 
>>> install.
>>>
>>> Thanks.
>>> -Abe
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users




More information about the postgis-users mailing list