[postgis-tickets] [PostGIS] #3166: normalize_address gives invalid regular expression error on input with parentheses

[PostGIS]

#3166: normalize_address gives invalid regular expression error on input with
parentheses
----------------------------+---------------------------
 Reporter:  alexreinhart    |      Owner:  robe
     Type:  defect          |     Status:  new
 Priority:  medium          |  Milestone:  PostGIS 2.1.8
Component:  tiger geocoder  |    Version:  2.1.x
 Keywords:                  |
----------------------------+---------------------------
 I'm geocoding addresses using 2013 TIGER data. I've encountered the
 following problem on a badly-formed address (which I have edited
 slightly):
 {{{
 crime=# SELECT normalize_address('307 Oakland Ave (Bouquet Garden a),
 Pittsburgh PA 15213');
 ERROR:  invalid regular expression: parentheses () not balanced
 CONTEXT:  PL/pgSQL function normalize_address(character varying) line 372
 at assignment
 }}}
 Strangely, deleting the "a" makes this query work.
 {{{
 crime=# SELECT normalize_address('307 Oakland Ave (Bouquet Garden),
 Pittsburgh PA 15213');
              normalize_address
 --------------------------------------------
  (307,,Oakland,Ave,,,Pittsburgh,PA,15213,t)
 (1 row)
 }}}
 My version is
 {{{
 PostgreSQL 9.3.8 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
 4.8.4-2ubuntu1~14.04) 4.8.4, 64-bit POSTGIS="2.1.2 r12389"
 GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL
 1.10.1, released 2013/08/26" LIBXML="2.9.1" LIBJSON="UNKNOWN" RASTER
 }}}

 Thanks.

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