[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
Resolution:           |   Keywords:  proj4, spatial_ref_sys
----------------------+------------------------------------

Comment (by jdrake):

 Replying to [ticket:4192 jdrake]:
 Correction - using postgis 2.5.0, not postgresql 2.5.0.
 > 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#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.