A couple things; executing any sql function is not a good thing from a 
security standpoint (but you know this). You should be able to advertise 
additional functions on a data store by datastore basis using the filter 
capabilities data structure. You are the first person to want to do this 
so please let me know if you have any questions.

I like your idea of storing the additional functions as a table; the 
best move would be to have the PostGISDataStoreFactory check for this 
table and make the correct implementations as needed.

Jody

Ben Caradoc-Davies wrote:
> I have written a prototype for "registered function" support in WFS 
> filter queries, in which functions not implemented in GeoServer are 
> passed to the database for execution. This allows complex or expensive 
> domain-specific queries to be performed on the database server side.
>
> Please comment if you think that this could be expanded or modified to 
> help you.
>
> See:
> http://jira.codehaus.org/browse/GEOT-1929
>
> Notes:
> - Only PostGIS is supported at the moment.
> - Only the community-schemas build has it
> - There is no register of functions, so all are permitted (SECURITY!) 
> (See GEOT-1930.)
>
> More and better support when this is merged onto trunk and into core.
>
> Credits go to Rob Atkinson for the concept, name, and advocating this 
> approach to users for about a year.  :-)
>
>   


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to