[postgis-tickets] [PostGIS] #3968: postgis geocode bug - invalid input syntax for type numeric

[PostGIS]

#3968: postgis geocode bug - invalid input syntax for type numeric
-----------------------------+---------------------------
  Reporter:  hammeryosi      |      Owner:  robe
      Type:  defect          |     Status:  new
  Priority:  medium          |  Milestone:  PostGIS 2.4.3
 Component:  tiger geocoder  |    Version:  2.4.x
Resolution:                  |   Keywords:
-----------------------------+---------------------------

Comment (by hammeryosi):

 Hi,
 Thanks for your answer and sorry it took me a while to reply. Haven't got
 back to this until now.

 Since posting this I set up another database with all states included.
 (Before I used different databases for different states to improve
 performance working on millions of addresses) The new database does not
 have this issue. The only difference between the setup process was using a
 different version of wget for downloading the census data. Could this have
 been something to do with a bad line in one of the census tables?
 I don't see how that would cause such a strange bug appearing only when
 specifying max_results=1.

 In any case, since this bug is not reproducible even on my machine. I
 think we can close it.

 Thanks again!

 Yosi

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3968#comment:3>
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.