queryByFeatures,oids,postgis

[Eduin Carrillo]

I were unable to query a postgis table using queryByFeatures. That table is big (18000 records), but it is indexed with GIST. It hasn't oid field, but it has a gid field (integer)  as primary key.

Quering another table with less records(7) returns records as expected.

Another post to the list points that issue (http://mapserver.gis.umn.edu/data2/wilma/mapserver-users/0310/msg00320.html)


EXPLAIN ANALYSE SELECT the_geom,gid FROM problematiclayer

Seq Scan on problematiclayer  (cost=0.00..2390.95 rows=18895 width=3407) (actual time=0.225..195.622 rows=18895 loops=1)

2 rows fetched (297 ms)
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 187638/1/0, nestlvl: 1, children: <>
DEBUG:  ProcessUtility
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 187638/1/0, nestlvl: 1, children: <>
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 187639/1/0, nestlvl: 1, children: <>
DEBUG:  ProcessUtility
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 187639/1/1, nestlvl: 1, children: <>

Software:
PostgreSQL 8.2.1
POSTGIS="1.2.1" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.5.0, 22 Oct 2006" USE_STATS
FIST 2.2.1


__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis! 
Regístrate ya - http://correo.espanol.yahoo.com/