[postgis-users] Error while importing data

strk at refractions.net strk at refractions.net
Fri Jun 3 17:36:57 PDT 2005


I downloaded your .sql file and it loads fine here:

$ psql -f country.sql 2> /tmp/er
BEGIN
NOTICE:  CREATE TABLE will create implicit sequence "country_gid_seq" for serial column "country.gid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "country_pkey" for table "country"
CREATE TABLE
                                  addgeometrycolumn
--------------------------------------------------------------------------------------
 geoserver.country.the_geom SRID:-1 TYPE:MULTIPOLYGON DIMS:2
 geometry_column fixed:0
(1 row)

INSERT 5406130 1
INSERT 5406132 1
INSERT 5406133 1
INSERT 5406135 1
INSERT 5406137 1
INSERT 5406139 1
INSERT 5406141 1
INSERT 5406146 1
INSERT 5406148 1
INSERT 5406150 1
INSERT 5406152 1
INSERT 5406153 1
INSERT 5406155 1
INSERT 5406157 1
INSERT 5406159 1
INSERT 5406160 1
INSERT 5406161 1
INSERT 5406163 1
INSERT 5406165 1
INSERT 5406167 1
INSERT 5406169 1
INSERT 5406171 1
INSERT 5406172 1
COMMIT

Postgis version is 1.0.1 installed from official package.

Another question: can you send description of your geometry_columns table ?
--strk;




More information about the postgis-users mailing list