On Mon, Oct 14, 2013 at 1:45 PM, Jonathan Moules <
[email protected]> wrote:
> Hi Andrea,
> But then surely as I've explicitly declared a schema in the Store that
> should be used? I guess expectations may be different between users, but
> that's what I'd expect to happen. I don't normally include the schema
> myself in any of my queries in any software I use - not even SQL Developer
> where I've entered raw SQL - it is always added transparently.
>
This is because these tools setup the "default schema" or "search path"
before giving you a sql
editor to play with.
GeoServer could do the same, it could be an extra sql that send to the
database when retrieving a connection from the pool.
Of course this would have a cost, it would result in an extra call to the
dbms, maybe we should limit it to sql views... and
not everybody would be happy to have it because of that.
Plus, as icing on the cake, setting the default schema uses db specific
sql, so one would have to setup all the dialects we have
with their own custom way of setting the schema (e.g., it's "set
search_path to 'schema'" for postgresql,
"ALTER SESSION SET CURRENT_SCHEMA=schema" for Oracle, and so on)
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
