[postgis-users] Newbie Tiger 2011 Loader Scripts issues

Michael Papet mpapet at yahoo.com
Fri Nov 2 18:08:30 PDT 2012

I think I have it figured out.

It was another case of the classic problem between the seat and the keyboard!

Thanks anyway.

 From: Michael Papet <mpapet at yahoo.com>
To: "postgis-users at lists.osgeo.org" <postgis-users at lists.osgeo.org> 
Sent: Friday, November 2, 2012 4:34 PM
Subject: Newbie Tiger 2011 Loader Scripts issues


I'm a newbie retrying the postgis stack version 2.1.0SVN dated  12/08/22
I have run into two issues with the loader script. Using Washington D.C. as the state name, it gave me a script that got error #1.  Using RI data, I got error #2.

#1. 2012-11-02 15:53:11 PDT ERROR:  INSERT has more target columns than expressions at character 413 
#2.  2012-11-02 15:54:22 PDT ERROR:  relation "tiger.county" does not exist at character 166

For #1, this is a clean installation.  I don't know if I messed some part of the install up or not.
For #2, table county is in public, not tiger.  Is there something wrong with my installation, or a bug in the script?

I can reproduce both issues.  Let me know if you need anything else to enlighten me as to where I've gone
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121102/1ba5efe1/attachment.html>

More information about the postgis-users mailing list