[postgis-users] shp2psql problem

[javier garcia - CEBAS]

Hello;

Thanks Jeff. Yes, the output is a SQL file ( with a lot of INSERT) that sees 
correct to me.

I've used the pipe as you said, and the table is created in the database, but 
the created table is empty. 

In the screen, as the process goes, I can see a lot of:

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

Is this ERROR normal?

If so, where could I look for errors in the process?

Thanks,

Javier
-----------------------------------------------------------------------------------------------
El Mié 27 Ago 2003 23:51, Jeff Lounsbury escribió:
> Do a bunch of sql statements get output to the screen as you run it? You
> have to pipe that output into the database to actually run them as
> shp2pgsql does not connect to the database itself.
> ex:
> shp2pgsql <arg1> <arg2> <arg3> | psql <dbname> -h<host> -p<port>
> -Jeff
>
> javier garcia - CEBAS wrote:
> > Hi all;
> > I've seen that other problems related to shp2psql have benn posted
> > previously to the list; but it didn't help me.
> >
> > I've an absolute beginner with postgis, and I've just installed it.
> >
> > I've got a shapefile (ESRI Arcmap8.1) that would like to import into
> > Postgres. So, when I saw this program I was absolutely happy.
> > I've run it and it appears to run correctly as no error message appears,
> > but, eventually, when I look up the new table in the database it doesn't
> > appears. So, it is simply not created.
> >
> > The shapefile is rather big, (about 5000 polygons).
> >
> > What could be the source of the problem?
> >
> > Best regards
> >
> > Javier
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users