[postgis-users] data loading problem

[Mark Cave-Ayland]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Chris Everhart
> Sent: 27 September 2005 19:30
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] data loading problem
> 
> 
> Hello all,
> 
> I am having a problem loading data to a database.  I am using a hosting 
> service that includes PostGIS and I have recently been moved to a
different 
> server.  When I run the command "psql -p 5434 -d BernaNM -f
den_jeffZip.sql" 
> (den_jeffZip.sql was created with shp2pgsql), this is the output:
> 
> -jailshell-2.05b$ psql -p 5434 -d BernaNM -f den_jeffZip.sql BEGIN
> psql:den_jeffZip.sql:2: NOTICE:  CREATE TABLE will create 
> implicit sequence 
> "den_jeffzip_gid_seq" for serial column "den_jeffzip.gid" CREATE TABLE
>                       addgeometrycolumn
> --------------------------------------------------------------
> public.den_jeffzip.the_geom SRID:-1 TYPE:MULTIPOLYGON DIMS:2 
> geometry_column fixed:0 (1 row)
> 
> When I get into the database and do a "\d" command, the new table does not

> show.  Also, I did a "select * from geometry_columns;" command and the
table 
> has not been updated.  I've tried several SQL insert files that have
worked 
> in the past and none have yielded any results.
> 
> Does the admin have to change any permissions on my account? Any other 
> suggestions?
> 
> Thanks people.
> 
> Christian


Hi Christian,

Looking at the output from your script, there appears to be a BEGIN tag but
no COMMIT tag - hence the server will not commit any changes. Can you check
to see that there is a COMMIT statement somewhere in your den_jeffZip.sql
file?

Also it could be that in moving server, you have been upgraded to a newer
version of PostGIS/PostgreSQL. If so, you may find that using the shp2pgsql
on your new server to regenerate your .sql files from your shapefiles may
give better results.


Kind regards,

Mark.

------------------------
WebBased Ltd
South West Technology Centre
Tamar Science Park
Plymouth
PL6 8BT 

T: +44 (0)1752 791021
F: +44 (0)1752 791023
W: http://www.webbased.co.uk