[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 robe):

 Hammer,

 I loaded NC tiger 2017 data and tested, and not seeing an issue.


 {{{
 SELECT geocode(normalize_address('6922 SURREY RD, FAYETTEVILLE, NC
 28306'), 1);
 }}}

 outputs:

 {{{
                                                 geocode

 --------------------------------------------------------------------------------
 ------------------------
 ("(6922,,Surrey,Rd,,,Fayetteville,NC,28306,t,,)",0101000020AD100000B4AED5924DC1
 53C0DFB3212DF17E4140,0)
 (1 row)
 }}}



 {{{
 SELECT geocode(normalize_address('6922 SURREY RD, FAYETTEVILLE, NC
 28306'));
 }}}

 outputs

 {{{
                                                 geocode

 --------------------------------------------------------------------------------
 ------------------------
 ("(6709,,Surrey,Rd,,,Fayetteville,NC,28306,t,,)",0101000020AD10000027ACEC8778C0
 53C09480511ED27F4140,5)
 ("(198,,Sarah,Ln,,,Rockfish,NC,28306,t,,)",0101000020AD1000007EBC9E12A8C353C07D
 C16057347D4140,71)
 (2 rows)

 }}}

 I'm running:

 {{{
 PostgreSQL 10.1, compiled by Visual C++ build 1800, 64-bit

 POSTGIS="2.4.2 r16113" PGSQL="100" GEOS="3.6.2-CAPI-1.10.2 4d2925d"
 PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.2, released 2017/09/15"
 LIBXML="2.7.8" LIBJSON="0.12" LIBPROTOBUF="1.2.1" RASTER
 }}}

 Very similar to yours, so I'm guessing you might be running an unpatched
 tiger geocoder.
 To check which version you are running, check what this outputs:


 {{{
 SELECT name, installed_version
 FROM pg_available_extensions WHERE name = 'postgis_tiger_geocoder';
 }}}



 {{{
           name          | installed_version
 ------------------------+-------------------
  postgis_tiger_geocoder | 2.4.1
 (1 row)
 }}}

 I thought maybe it was something I fixed in 2.4.2, but as you can see I
 neglected to even upgrade my tiger to 2.4.2, so in theory I should be
 running the same version as you.

 If you see something less than 2.4.1, then run this:


 {{{
 ALTER EXTENSION postgis_tiger_geocoder UPDATE;
 }}}

 and that should bring you up to date.  Hopefully will fix your issue.

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