Skip to main content
1 of 2

st_transform returning different results in postgis 2.4.3 and postgis 3.0.2

Getting this in 2.4.3

select st_astext(st_transform(st_setsrid(st_geomfromtext('POINT(-13279706.1692 5957543.84253624)'), 900913), 4326));
                 st_astext
 -------------------------------------------
 POINT(-119.293630204087 47.0946914247282)
(1 row)

And this in 3.0.2

select st_astext(st_transform(st_setsrid(st_geomfromtext('POINT(-13279706.1692 5957543.84253624)'), 900913), 4326));
             st_astext
-------------------------------------------
 POINT(-119.293630204087 47.2862076625893)
(1 row)

I've confirmed that the definitions for both 900913 and 4326 are identical in spatial_ref_sys. Not sure how to even go about troubleshooting this...