[postgis-users] Using shp2pgsql

[White, Richard]

There is posibly something wrong with the schema.

 

I have just had the same problem. Removed the schema definition from the
shp2pgsql command and then ran psql again and it loaded fine. However,
it loaded into the public schema.

 

So it must be to do with the schema.

 

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Maddock
Sent: 25 April 2012 16:02
To: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] Using shp2pgsql

 

Nothing, the sql file looks beautiful.  No errors.  The interesting
thing to me is that it repeats the error when I pipe it and the error
repeats for as many time as there are rows of data.

 

What could this mean?  Might there be something wrong with my schema?  

 

 

Shp2psql is supposed to create the table which it does:

SET CLIENT_ENCODING TO UTF8;

SET STANDARD_CONFORMING_STRINGS TO ON;

BEGIN;

CREATE TABLE "columbus"."pole_region" (gid serial PRIMARY KEY,

"location_n" varchar(15),

"height" float8,

"class" varchar(11),

"ownership" varchar(7),

"owner" varchar(80),

"plant_acct" varchar(31),

"vintage_ye" float8,

"inservice_" varchar(12),

"pole_kind" varchar(31),

"pole_type" varchar(24),

"original_t" varchar(25),

"design_sta" varchar(18),

"facility_s" varchar(10),

"ciac_statu" varchar(8),

"ciac_date" varchar(12),

"west_pole_" varchar(6));

SELECT
AddGeometryColumn('columbus','pole_region','geom_3754','3754','MULTIPOLY
GON',4);

 

From: Denis Rouzaud [mailto:denis.rouzaud at gmail.com] 
Sent: Wednesday, April 25, 2012 10:52 AM
To: PostGIS Users Discussion
Cc: Paul Maddock
Subject: Re: [postgis-users] Using shp2pgsql

 

You could output shp2pgsql to a SQL file, then use it in psql to see at
which line the error occurs.



On 04/25/2012 04:46 PM, Paul Maddock wrote: 

Dear all,

 

I'm using the following code to transform a shapefile I have into a
table and import it into my database:

shp2pgsql -s 3754 ~/JOE/columbus/pole_region.shp columbus.pole_region |
psql -h localhost -U postgres -p 5432 -d paul

 

When it runs I have to put my password in for postgres (expected), and I
get the following output:

 

ERROR:  current transaction is aborted, commands ignored until end of
transaction block

ERROR:  current transaction is aborted, commands ignored until end of
transaction block

ERROR:  current transaction is aborted, commands ignored until end of
transaction block

ERROR:  current transaction is aborted, commands ignored until end of
transaction block

ERROR:  current transaction is aborted, commands ignored until end of
transaction block

ERROR:  current transaction is aborted, commands ignored until end of
transaction block

ERROR:  current transaction is aborted, commands ignored until end of
transaction block

ERROR:  current transaction is aborted, commands ignored until end of
transaction block

ERROR:  current transaction is aborted, commands ignored until end of
transaction block

ERROR:  current transaction is aborted, commands ignored until end of
transaction block

ERROR:  current transaction is aborted, commands ignored until end of
transaction block

ERROR:  current transaction is aborted, commands ignored until end of
transaction block

ERROR:  current transaction is aborted, commands ignored until end of
transaction block

 

The database paul is created and the schema columbus is created and is
owned by postgres. 

 

What am I doing wrong?  Do I have to set datatypes?

 

Thanks for the help,

Paul

 

 

Paul A. Maddock

Mapping Technician

IJUS LLC

560 Officenter Place

Gahanna, OH 43230

Cell: (513) 404-6476

  <http://www.ijus.net/index.html> 

 





_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Infoterra Ltd. Is part of the Astrium GEO-Information Services Division and a wholly owned subsidiary of Astrium, Europe's leading space systems and services specialist.

Disclaimer. The information contained in this e-mail and its attachments are confidential and intended only for the use of the named addressee(s). If you are not the intended addressee, please do not read, copy, use or disclose this message or its attachments. If you have received this message in error, please notify the sender immediately and delete or destroy all copies of this message and attachments in all media. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Infoterra Ltd and shall not form part of any binding agreement.

Infoterra Limited a company registered in England under number 2359955 and having its registered office at Atlas House, 41 Wembley Road, Leicester, LE3 1UT. VAT number GB 476 0468 27. 

P Before printing, think about the environment 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120425/2799a20d/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 3201 bytes
Desc: image001.gif
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120425/2799a20d/attachment.gif>