[postgis-users] data loading problem

[Chris Everhart]

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

_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from McAfee® 
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963