<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div>I think I figured the stuff out I was doing wrong, but now I'm at a loss for the query errors that follow.</div><div><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">I'm using Debian's postgresql 9.1 and PostGIS 2.0SVN. I got the Tigetr2010 loader script that generated the error using the following example: SELECT loader_generate_script(ARRAY['WI', 'WY', 'DC'], 'sh') AS result;</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">I get the following
errors in my Postgresql log and I don't know if they mean anything.<br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">2012-11-02 18:00:31 PDT ERROR: INSERT has more expressions than target columns at character 294<br>2012-11-02 18:00:31 PDT QUERY: INSERT INTO tiger_data.dc_tabblock(the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp) SELECT the_geom,intptlon10,intptlat10,awater10,aland10,funcstat10,uatyp10,uace10,ur10,mtfcc10,name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10 FROM tiger_staging.dc_tabblock10;<br>2012-11-02 18:00:31 PDT CONTEXT: PL/pgSQL function "loader_load_staged_data" line 24
at EXECUTE statement<br><br>2012-11-02 19:56:18 PDT ERROR: syntax error at or near "FROM" at character 637<br>2012-11-02 19:56:18 PDT QUERY: INSERT INTO tiger_data.wi_faces(the_geom,intptlon,intptlat,atotal,"offset",lwflag,nctadvfp,nectafp,cnectafp,metdivfp,cbsafp,csafp,puma5ce,ugace,tazce,zcta5ce,vtdst,sldlst,sldust,cd111fp,uace,unsdlea,scsdlea,elsdlea,tblkgpce,ttractce,anrcfp,trsubce,trsubfp,comptyp,aiannhce,aiannhfp,placefp,conctyfp,submcdfp,cousubfp,blockce,blkgrpce,tractce,countyfp,statefp,puma5ce00,ugace00,tazce00,zcta5ce00,vtdst00,sldlst00,sldust00,cd108fp,uace00,unsdlea00,scsdlea00,elsdlea00,anrcfp00,trsubce00,trsubfp00,comptyp00,aiannhce00,aiannhfp00,placefp00,conctyfp00,submcdfp00,cousubfp00,blockce00,blkgrpce00,tractce00,countyfp00,statefp00,tfid) SELECT FROM tiger_staging.wi_faces;<br><br>2012-11-02 19:55:50 PDT STATEMENT: ALTER TABLE tiger_staging.WI_tabblock10 RENAME geoid10 TO tabblock_id; SELECT
loader_load_staged_data(lower('WI_tabblock10'), lower('WI_tabblock'));<br><br>2012-11-02 20:43:19 PDT ERROR: column "tabblock_id" does not exist at character 246<br>2012-11-02 20:43:19 PDT STATEMENT: INSERT INTO tiger_data.wi_tabblock(the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp)<br> SELECT the_geom,intptlon10,intptlat10,awater10,aland10,funcstat10,uace10,ur10,mtfcc10,name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10 FROM tiger_staging.wi_tabblock10;<br><br></div></div></body></html>