[postgis-tickets] [PostGIS] #2941: Geography can create a non-4326 geography but geography typmod won't allow it

PostGIS trac at osgeo.org
Sat Sep 27 17:48:21 PDT 2014


#2941: Geography can create a non-4326 geography but geography typmod won't allow
it
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.1.5
Component:  postgis  |     Version:  2.1.x        
 Keywords:           |  
---------------------+------------------------------------------------------
 Both Paul and I recall that the geography type had support for other long-
 lat spatial reference systems when 2.1.0 was released.

 http://lists.osgeo.org/pipermail/postgis-devel/2014-September/024532.html
 When trying this it fails:

 {{{
 CREATE TABLE test(gid serial,geog geography(multilinestring,4269));
 }}}


 However I can do this:


 {{{
 SELECT geography(ST_GeomFromText('POINT(1 1)', 4269));

 and this:
 SELECT geography(ST_GeomFromText('POINT(1 1)', 4269)) As geog
 INTO test3;

 SELECT ST_SRID(geog::geometry) from test3;

 --yields 4269 as expected.


 }}}


 I thought it was a regression bug, but trying the above on a 2.1.0 install
 I found lying around yields the same results.  So it seems while the
 geography type supports non-4326 lon lat spatial reference systems,  you
 can't insert these into a geography table.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2941>
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