I have a number of shapefiles (converted from VMAP0 data) loaded into a
PostGIS DB that is running locally on the same machine as GeoServer.
I logged in as administrator and went to the 'GeoServer Configuration'
page. From there, I clicked on 'Data' and created a new DataStore called
'polbnda_shapefile'. It was configured as a PostGIS data store with the
following information:
DataStore ID: polbnda_shapefile
Enabled: checked
Namespace: topp
Description:
* host: localhost
* port: 5432
schema: polbnda
* database: vmap0
* user: brownje2
passwd: xxxxxxxx
wkb enabled: true
loose bbox: true
I then clicked 'Apply' and 'Save'.
Then I try to create a feature type using the above datastore and I get
the following error:
SQL Error building FeatureType for shp:r ERROR: relation "shp:r" does
not exist
Here is the SQL that created the table:
CREATE TABLE polbnda."shp:r"
(
gid int4 NOT NULL DEFAULT
nextval('polbnda."shp:r_gid_seq"'::regclass),
id int8,
f_code varchar,
nam varchar,
na2 varchar,
na3 varchar,
tile_id int4,
fac_id int8,
the_geom geometry,
CONSTRAINT "shp:r_pkey" PRIMARY KEY (gid),
CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) =
'MULTIPOLYGON'::text OR the_geom IS NULL),
CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 4326)
)
WITHOUT OIDS;
When I use the pgAdmin III tool and check out vmap.polbnda I see a table
name 'shp:r'. What's the problem?
Thanks!
JAB