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

[PostGIS]

#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:           |  
---------------------+------------------------------------------------------
Description changed by robe:

Old description:

> 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.

New description:

 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.

 -- this correctly rejects as expected

 SELECT geography(ST_GeomFromText('POINT(1 1)', 26986)) As geog;

 erros out with;
 ERROR:  Only lon/lat coordinate systems are supported in geography.
 }}}


 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#comment:1>
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.