Hi,
I have a postgis schema ("IBIS") with some views that have an entry in the
GT_PK_METADATA table but I keep seeing the message "No primary key or
unique index found for v_grootste_10_bedrijven_op_terrein." in my logs.
Stepping through in the debugger I can see the statement "SELECT * FROM
IBIS.GT_PK_METADATA WHERE 1 = 0" being prepared and executed and
consequently failing with an exception
e = (org.postgresql.util.PSQLException) org.postgresql.util.PSQLException:
ERROR: relation "ibis.gt_pk_metadata" does not exist
Position: 15
Because the sql is invalid for postgis, the schema name should be quoted..
HeuristicPrimaryKeyFinder seems to be using the encodeTableName() of the
store to circumvent that.
I've filed an issue: https://osgeo-org.atlassian.net/browse/GEOT-5349 and
can probably prepare a PR with a fix
I've just submitted https://github.com/geotools/geotools/pull/1096 for
https://osgeo-org.atlassian.net/browse/GEOT-4886, so I would include that.
Mark
--
Disclaimer;
This message is just a reflection of what I thought at the time of sending.
The message may contain information that is not intended for you or that
you don't understand.
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
