[postgis-devel] shp2pgsql - Cannot use both -D and -r

Mark Cave-Ayland mark.cave-ayland at ilande.co.uk
Fri Jun 8 05:47:20 PDT 2012


On 16/05/12 07:25, Lauri Kajan wrote:

> Hi all,
>
> When trying to import shape files with a command:
> shp2pgsql -c -D -s 3067 -i -N skip -W CP1252 C:\myshape.shp mytable |
> psql -d postgis
>
> I got an error "Cannot use both -D and -r". What is the -r parameter?
> Should it be -s?
> I removed the s parameter and then it worked. But now all my tables
> are without srid.
> I think the same command has worked before.
> Why the srid setting has been disabled when using dump or is this a bug?
>
>
> I had the latest windows version from the Stack Builder.
>
> -Lauri

Hi Lauri,

I've had a look at this, and found a better way of parsing the valid 
argument combinations in shp2pgsql. It will need someone to double-check 
this on Windows though.


ATB,

Mark.



More information about the postgis-devel mailing list