[postgis-users] Re: Problem loading shape data (Paul Ramsey)

[John Zhang]

Thank you, Paul. The encoding does make it work better. However, only half
the data transferred. (raw data with 518 rows, new with 269 rows ). Without
-W LATIN1 option, only 11 rows got transferred. Any other options?

Thanks a lot.
John

Subject: Re: [postgis-users] Re: Problem loading shape data (Paul
       Ramsey)
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID:
       <30fe546d0812151227p48de9c10qfdce3694145c3d09 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Try adding -W LATIN1 to your shp2pgsql invocation. You have some
(garbage?) hibit characters in your file.

P

On Mon, Dec 15, 2008 at 12:14 PM, John Zhang <johnzhang06 at gmail.com> wrote:
> oops............here are the attachments
>
> On Mon, Dec 15, 2008 at 9:58 AM, John Zhang <johnzhang06 at gmail.com> wrote:
>>
>>  Hi Paul,
>>
>> Thank you very much for the input and the hint on how to get the whole
>> error message.
>> Attached are the error message file and the generated script file for
your
>> reference.
>>
>> The commands used are:
>>
>> shp2pgsql -s 3005 "..\AbaloneClosures.shp" hm_vect.AbaloneClosures2 >
>> D:\tmp\AbaloneClosures2.sql
>> psql -h flash.HaidaMapping.local -d hm -U  postgres -f
>> D:\tmp\AbaloneClosures2.sql
>>
>> Based on the error message, the table "hm_vect"."abaloneclosures2" seemed
>> created. However, it is not.
>>
>> Your input on the problem would be much appreciated!
>>
>> Thanks
>> John
>>
>>> Date: Sat, 13 Dec 2008 16:36:00 -0800
>>> From: "Paul Ramsey" <pramsey at cleverelephant.ca>
>>> Subject: Re: [postgis-users] Problem loading shape data
>>> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
>>> Message-ID:
>>>        <30fe546d0812131636v212853d8wa3422f29f4e142fc at mail.gmail.com>
>>> Content-Type: text/plain; charset=ISO-8859-1
>>>
>>> You have to scroll up in the window until you can see what the
>>> *actual* error is... increase your command terminal scroll buffers to
>>> 5000 then re-run and scroll up to the first error message.
>>>
>>> On Fri, Dec 12, 2008 at 3:17 PM, John Zhang <johnzhang06 at gmail.com>
>>> wrote:
>>> >  Hi there,
>>> >
>>> > I used shp2pgsql command to convert shape data to postgis. I met a
>>> > problem
>>> > when I tried to run the generated sql data file.
>>> >
>>> > The command is as follows:
>>> >
>>> > shp2pgsql -s 3005 "..\AbaloneClosures.shp" hm_vect.AbaloneClosures >
>>> > D:\tmp\AbaloneClosures.sql | psql -h flash.HaidaMapping.local -d hm -U
>>> > postgres -f D:\tmp\AbaloneClosures.sql
>>> >
>>> > the message tells: "..current transaction is aborted..". However, when
>>> > I
>>> > copied the command to a query window to run, it was successful. It is
a
>>> > polygon feature class with less than 1000 rows.
>>> >
>>> > When I ran
>>> > psql -h flash.HaidaMapping.local -d hm -U postgres -f
>>> > D:\tmp\AbaloneClosures.sql
>>> > the same problem occurred.
>>> >
>>> > Any input would be appreciated.
>>> >
>>> > Thanks a lot
>>> > John
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081216/1f4adc71/attachment.html>