[postgis-users] oid indexes issue

[Paul Ramsey]

Tom, use the below:

Kralidis,Tom [Burlington] wrote:

> # CREATE TABLE service_endpoints (
>  resource_id serial primary key,
>  title text,
> );
> 
> # SELECT AddGeometryColumn
> ('service_endpoints','the_geom',4326,'MULTIPOLYGON',2);
> 
> # CREATE INDEX service_endpoints_idx ON service_endpoints USING GIST (
> the_geom GIST_GEOMETRY_OPS );
> 
> 
> This works successfully against

And for your mapserver DATA statement:

"the_geom from service_endpoints using SRID=4325 using unique resource_id"


Paul