[postgis-users] problem with shp2pgsql

[strk at refractions.net]

On Wed, Dec 28, 2005 at 04:08:07PM +0100, Barend Köbben wrote:
> Hi Henok,
>  
> possible solutions:
>  
> 1) you do not include the [schema.]database in the paramters. Not sure if it is required, but it might be, so uit would be:
> ./shp2pgsql -s 26911  River.shp  River  [mySchema.]myDB> River.sql
>  
> 2) you have only copied the *.shp file to the loader directory, but not the other associated (and needed fiel). These include at least *.dbf and  *.shx , in many cases also *.sbn, *.prj or *.sbx

I bet on (2) 

"Can't open" message is pretty clear, unfortunately shapelib abstraction
does not make it easy to be clearer than that (wheter it's .shx or .shp
failing to open). Also, check for CorrectCasing.

--strk;