Re: [postgis-users] shp2pgsql Solved

2009-07-29 Thread Mark Cave-Ayland
Paragon Corporation wrote: 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 Le

Re: [postgis-users] shp2pgsql Solved

2009-07-28 Thread Ravi
Hi Leo, but it is a fact would like to probe why.. Data file available at http://2007.foss4g.org/workshops/W-04/data.zip bc_roads.shp Ravi --- On Wed, 29/7/09, Paragon Corporation wrote: > From: Paragon Corporation > Subject: Re: [postgis-users] shp2pgsql Solved > To: "

Re: [postgis-users] shp2pgsql Solved

2009-07-28 Thread Paragon Corporation
al Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@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 t

Re: [postgis-users] shp2pgsql Solved

2009-07-28 Thread Ravi
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 p