[postgis-tickets] [PostGIS] #5294: Postgis st_transform error: SQL Error [XX000]: ERROR: could not form projection (LWPROJ) from 'srid=7801' to 'srid=4326'

PostGIS trac at osgeo.org
Tue Nov 29 00:24:02 PST 2022


#5294: Postgis st_transform error: SQL Error [XX000]: ERROR: could not form
projection (LWPROJ) from 'srid=7801' to 'srid=4326'
-----------------------+---------------------------
 Reporter:  iknikolov  |      Owner:  pramsey
     Type:  defect     |     Status:  new
 Priority:  medium     |  Milestone:  PostGIS 3.3.3
Component:  postgis    |    Version:  3.3.x
 Keywords:             |
-----------------------+---------------------------
 I have 4 servers with the same versions of OS (Ubuntu 20.04), Postgis and
 Postgre:




 {{{
 POSTGIS="3.2.1 5fae8e5" [EXTENSION] PGSQL="130" GEOS="3.10.1-CAPI-1.16.0"
 PROJ="6.3.1" LIBXML="2.9.10" LIBJSON="0.13.1" LIBPROTOBUF="1.3.3"
 WAGYU="0.5.0 (Internal)"

 PostgreSQL 13.6 (Ubuntu 13.6-1.pgdg20.04+1) on x86_64-pc-linux-gnu,
 compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit
 }}}


 The query below works on any server except one:



 {{{
 SELECT
     st_asgeojson(st_transform("table-name".geom, 4326)) AS way
     FROM "table-name"
 }}}



 The server with the issue responds whiy this error:


 {{{
 SQL Error [XX000]: ERROR: could not form projection (LWPROJ) from
 'srid=7801' to 'srid=4326'
 }}}

 I upgraded the PostGIS server to 3.3.2 but the result is the same.

 Can you help me?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5294>
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