[postgis-tickets] [PostGIS] #2870: Binary insert into geography column results in value being inserted as geometry.
PostGIS
trac at osgeo.org
Tue Aug 5 21:23:24 PDT 2014
#2870: Binary insert into geography column results in value being inserted as
geometry.
------------------------+---------------------------------------------------
Reporter: andrewdone | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.1.4
Component: postgis | Version: 2.1.x
Keywords: |
------------------------+---------------------------------------------------
Comment(by robe):
This is interesting
I noticed if I add this
{{{
insert into px(pt) values
('0101000020E610000009C6C1A5E3E662406BB75D68AEED40C0'::geometry);
select id, pt, ST_Summary(pt) from px;
}}}
I get:
{{{
id | pt | st_summary
----+----------------------------------------------------+------------
1 | 0101000020E610000009C6C1A5E3E662406BB75D68AEED40C0 | Point[GS]
2 | 0101000020E610000009C6C1A5E3E662406BB75D68AEED40C0 | Point[GS]
3 | 0101000020E610000009C6C1A5E3E662406BB75D68AEED40C0 | Point[BGS]
}}}
How come the one I create with geometry cast has a cached bounding box and
the others don't?
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2870#comment:7>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list