[postgis-users] Geocoder questions (PG 9.0/ Posgis 2.0 SVN)

fork forkandwait at gmail.com
Tue Mar 22 11:33:56 PDT 2011


fork <forkandwait <at> gmail.com> writes:

> 1.  I am getting an error to the effect that
> geometry type is not found in a
> database, but I am able to find it with \dT 
>and I have successfully installed
> postgis in its own schema with search_path.  Any ideas?

Well, I added the following to all the *.sql files 
cited in create_geocode.bat:

BEGIN;
SET search_path TO tiger,public,postgis;
\set ON_ERROR_STOP 1

... original file here ...

COMMIT;

And it seems to work, though I am currently loading 
a couple of states to play with.

Great job!  




More information about the postgis-users mailing list