Opened 10 years ago
Last modified 10 years ago
#2941 closed defect
Geography can create a non-4326 geography but geography typmod won't allow it — at Initial Version
Reported by: | robe | Owned by: | pramsey |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS 2.1.6 |
Component: | postgis | Version: | 2.1.x |
Keywords: | Cc: |
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.
Note:
See TracTickets
for help on using tickets.