[postgis-tickets] [PostGIS] #4192: org.postgresql.util.PSQLException: ERROR: AddToPROJ4SRSCache: could not parse proj4 string

[PostGIS]

#4192: org.postgresql.util.PSQLException: ERROR: AddToPROJ4SRSCache: could not
parse proj4 string
------------------------------------+---------------------------
 Reporter:  jdrake                  |      Owner:  pramsey
     Type:  defect                  |     Status:  new
 Priority:  medium                  |  Milestone:  PostGIS 2.5.1
Component:  postgis                 |    Version:  1.4
 Keywords:  proj4, spatial_ref_sys  |
------------------------------------+---------------------------
 Using postgresql 2.5.0 (Ubuntu 18.4 package postgresql-10-postgis-2.5), I
 was getting the following exception from the query
 ST_Transform(ST_GeomFromText('POINT(...)', 4326), 102008):

 org.postgresql.util.PSQLException: ERROR: AddToPROJ4SRSCache: could not
 parse proj4 string '+proj=aea +lat_1=20.0 +lat_2=60.0+lat_0=40.0+lon_0=-96
 +x_0=0 +y_0=0 +ellps=GRS80 +datum=NAD83 +units=m no_defs' unknown unit
 conversion id SQL state: XX000

 This appeared to be fixed by manually changing the proj4text to have a '+'
 in front of no_defs:
 update spatial_ref_sys set proj4text='+proj=aea +lat_1=20.0
 +lat_2=60.0+lat_0=40.0+lon_0=-96 +x_0=0 +y_0=0 +ellps=GRS80 +datum=NAD83
 +units=m +no_defs' where srid = 102008

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