Opened 3 years ago

Closed 3 years ago

#4959 closed defect (fixed)

Drop Colorado state files also drops national county tables

Reported by: robe Owned by: robe
Priority: high Milestone: PostGIS 2.5.6
Component: tiger geocoder Version: 2.5.x -- EOL
Keywords: Cc:

Description

Issue is _ is a reserved filter in SQL. So LIKE 'co_%' also matches the county tables.

Change History (10)

comment:1 by pramsey, 3 years ago

Milestone: PostGIS 3.1.3 → PostGIS 3.1.4

comment:2 by robe, 3 years ago

Milestone: PostGIS 3.1.4 → PostGIS 2.5.6

comment:3 by Regina Obe <lr@…>, 3 years ago

In b4d57be/git:

Prevent _ from matching any character. References #4959 for PostGIS 3.2.0

comment:4 by Regina Obe <lr@…>, 3 years ago

In 1d66b61/git:

Prevent _ from matching any character. References #4959 for PostGIS 2.5.6

comment:5 by Regina Obe <lr@…>, 3 years ago

In 6a093cce/git:

Prevent _ from matching any character. References #4959 for PostGIS 2.5.6. Mistake on last commit

comment:6 by Regina Obe <lr@…>, 3 years ago

In f86f090/git:

Prevent _ from matching any character. References #4959 for PostGIS 3.2.0. Mistake on last commit

comment:7 by Regina Obe <lr@…>, 3 years ago

In d366152/git:

Prevent _ from matching any character. References #4959 for PostGIS 3.0.4.

comment:8 by robe, 3 years ago

Summary: Drop colorado also drops county files → Drop colorado also drops national county tables

comment:9 by robe, 3 years ago

Summary: Drop colorado also drops national county tables → Drop Colorado state files also drops national county tables

comment:10 by Regina Obe <lr@…>, 3 years ago

Resolution: → fixed
Status: new → closed

In 10d45cd/git:

Fixes and enhancements for postgis_tiger_geocoder. Closes #4958 Closes #4959 for PostGIS 3.1.4

Note: See TracTickets for help on using tickets.