History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: GEOS-1941
Type: Bug Bug
Status: Resolved Resolved
Resolution: Won't Fix
Priority: Minor Minor
Assignee: Andrea Aime
Reporter: Milo van der Linden
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
GeoServer

FeatureType cannot be created for postGIS table with single point

Created: 20/May/08 09:20 AM   Updated: 20/May/08 09:24 AM
Component/s: Configuration
Affects Version/s: 1.6.2
Fix Version/s: 1.6.2

Time Tracking:
Not Specified

Environment: Debian 4.0 rc2

Testcase included: yes


 Description  « Hide
When I create a spatial table in postgis with the following:

CREATE TABLE points
(
gid serial NOT NULL,
point_type integer,
the_geom geometry,
CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL),
CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 4326)
)
WITHOUT OIDS;
ALTER TABLE points OWNER TO postgres;

insert into points(point_type, the_geom) values (0,SetSRID(MakePoint(50,50),4326))

I cannot create a featureType for this table because Geoserver reports:

The FeatureType 'point' has a NULL extent.
HINT: the dataset is empty or has no default geometry attribute.



 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Milo van der Linden - 20/May/08 09:24 AM
This bug appears if the "type" column in postGIS geometry_columns table does not match the geometry_type for the point table.

I resolved this issue by altering the contents of type in the geometry_columns table.