[Geotools-devel] [jira] Created: (GEOT-3157) creating schemas in postgis is nondeterministic in which spatial type is entered into geometry_columns

2010-06-23 Thread Chris Van Orman (JIRA)
creating schemas in postgis is nondeterministic in which spatial type is entered into geometry_columns -- Key: GEOT-3157 URL: http://jira.codehaus.org/browse/GEOT-

Re: [Geotools-devel] Parametrized sql views: what mechanism to provide the parameters?

2010-06-23 Thread Michael Bedward
On 23 June 2010 17:21, Andrea Aime wrote: > Votes please :-) > I like the env function approach over yet more hints, but I'm probably biased :) Michael -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad F

Re: [Geotools-devel] Parametric SQL views, this time for good

2010-06-23 Thread christian . mueller
No, no, there is nothing special about DB2 (except the details, of course). I did my vote +0, Andrea can go on. For providing the parameters I cite Andrea "it's there where you'd expect it to be, in the Query" and that is my preference. Quoting Jody Garnett : > So to bring things back on

Re: [Geotools-devel] Parametric SQL views, this time for good

2010-06-23 Thread Jody Garnett
So to bring things back on track; Christian how are you doing with the idea being put forth - is it actually going to cause trouble for DB2? Or is it something that DB2 needs to handle differently. Jody On 23/06/2010, at 2:26 PM, christian.muel...@nvoe.at wrote: > Some clarifications. DB2 make

[Geotools-devel] Parametrized sql views: what mechanism to provide the parameters?

2010-06-23 Thread Andrea Aime
Hi, for the parametrized sql views thing we have two possible mechanisms. Reusing the env function just like in SLD parameter substitution. Pros: - it reuses the only param substitution mechanism we already have - easy to code up Cons: - if you're not already familiar with SLD param substitution