[postgis-tickets] [PostGIS] #5388: TIGER 2022 faces changed

[PostGIS]

#5388: TIGER 2022 faces changed
-----------------------------+---------------------------
  Reporter:  robe            |      Owner:  robe
      Type:  defect          |     Status:  new
  Priority:  medium          |  Milestone:  PostGIS 3.1.9
 Component:  tiger geocoder  |    Version:  3.3.x
Resolution:                  |   Keywords:
-----------------------------+---------------------------
Comment (by robe):

 updating exclude columns for faces seems to fix the issue.


 {{{
 UPDATE loader_lookuptables SET columns_exclude =
 '{gid,geoid,cpi,suffix1ce,statefp00,statefp10,countyfp00,countyfp10,tractce00,tractce10,blkgrpce00,blkgrpce10,blockce00,blockce10,cousubfp00,submcdfp00,conctyfp00,placefp00,aiannhfp00,aiannhce00,comptyp00,trsubfp00,trsubce00,anrcfp00,elsdlea00,scsdlea00,unsdlea00,uace00,cd108fp,sldust00,sldlst00,vtdst00,zcta5ce00,tazce00,ugace00,puma5ce00,vtdst10,tazce10,uace10,puma5ce10,tazce,uace,vtdst,zcta5ce10,puma5ce,ugace10,pumace10,estatefp,ugace,blockce,pumace20,sdadmlea,uace20}'::text[]
 WHERE lookup_name = 'faces';
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5388#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.