TIGER 2022 faces changed

[robe]

Looks like Census decided to update TIGER 2022 data again, adding an additional column to faces.

[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';

[Regina Obe <lr@…>]

In 7aef48a5/git:

Fix tiger 2022 faces load

• Add uace20 to exclusions column list

References #5388 for PostGIS 3.4.0

[Regina Obe <lr@…>]

In 5a935c7/git:

Fix tiger 2022 faces load

• Add uace20 to exclusions column list

References #5388 for PostGIS 3.3.3

[robe]

I guess I don't have tiger_2022 for prior versions, so stops at 3.3