[Geotools-gt2-users] Postgres View Problem

[<ko...@gm...>]

Hey,

I'm using uDig and GeoTools (version 2.6.5). Recently, I created a view that is showing 400.000 rows. During the start up, geotools takes about 90 seconds to perform buildFeatureType() method of the type org.geotools.jdbc.JDBCFeatureSource. 

ResultSet columns = metaData.getColumns(null, databaseSchema, tableName, "%");
while (columns.next()) {
    //...
}

Apparently, this loop is performed 400.000 times. Right before, I'm getting the message:

"No primary key or unique index found for view_yyyy"

I'm not sure if this is somehow related to the behavior. I appreciate any suggestions.

Thanks.

Kon
-- 
GRATIS! Movie-FLAT mit über 300 Videos. 
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome