[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:

SET search_path TO tiger,public,postgis;

... original file here ...


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