[postgis-users] shp2pgsql Solved

Paragon Corporation lr at pcorp.us
Tue Jul 28 14:48:04 PDT 2009


Ravi,

Shouldn't be.  The -i in shp2pgsql is  to use int4 (not the version of psql
or anything of that sort).  I don't believe that has changed in a while.
  Not quite sure how that would play a role, though could I guess if int
behavior has changed between 8.2/8.4

Leo

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Ravi
Sent: Tuesday, July 28, 2009 5:38 PM
To: postgis
Subject: Re: [postgis-users] shp2pgsql Solved


Hi,
shp2pgsql –i –D -s 3005 bc_pubs.shp bcpubs > bc_pubs.sql this issues an
error from command prompt > Error: 'Access Denied'

Removing -i makes it work..
shp2pgsql  –D -s 3005 bc_pubs.shp bcpubs > bc_pubs.sql

Is this because I use a much advanced Pgsql 8.3

and the exercise attempted includes postgresql-8.2.msi only ?

Ravi



--- On Mon, 27/7/09, Ravi <ravivundavalli at yahoo.com> wrote:

> From: Ravi <ravivundavalli at yahoo.com>
> Subject: shp2pgsql
> To: "postgis" <postgis-users at postgis.refractions.net>
> Date: Monday, 27 July, 2009, 4:22 AM
> Hi,
> trying to create an SQL for a shape file.
> shp2pgsql –i –D -s 3005 bc_pubs.shp bcpubs > bc_pubs.sql this issues 
> an error from command prompt
> Error: 'Access Denied'
> 
> My Vista user = Ravi
> PostGIS user = postgres
> 
> any suggestions pl
> Ravi
> 
> 
>       See the Web's breaking stories,
> chosen by people like you. Check out Yahoo! Buzz. 
> http://in.buzz.yahoo.com/
> 


      See the Web's breaking stories, chosen by people like you. Check
out Yahoo! Buzz. http://in.buzz.yahoo.com/
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users





More information about the postgis-users mailing list