[postgis-devel] Re: PostGIS datastore creation

[Paul Ramsey]

Mateusz,

Go ahead with the assumption that you can just issue a "CREATE  
DATABASE <dbname> WITH TEMPLATE = 'template_postgis' "  and we'll  
work on making sure that template_postgis exists at the server  
side...  You might want to check the existence of the template as  
part of seeing if you'll advertise this capability to clients.

Paul

On 21-Sep-06, at 1:31 AM, Mateusz Loskot wrote:

> Jason Birch wrote:
>> Mateusz Wrote:
>>> I talked about it with Bob Bray (on FOSS4G) and he told me that a
>>> provider is not required to support Create Data Store operation  
>>> to be a
>>> valid FDO provider.
>>> So, if there are some big problems and if it's not crucial for  
>>> PostGIS
>>> FDO users, we can safely not implement this capability.
>>
>> I think it's important that this FDO operation be supported, even if
>> creating the template_postgis template has to be a manual step in the
>> database installation process.
>
> Yes, I also think it's important.
> I just wanted to share what I was talking about with Bob Bray.
>
>> I would want to tightly control who has access to create  
>> databases, but
>> not allowing a small shop to turn on the ability for users to  
>> create new
>> data stores would limit the reach of the provider considerably; these
>> smaller shops are likely going to be the first to integrate  
>> PostGIS with
>> MapGuide and Map 3D.
>
> I see. It makes sense for me.
>
>
> Cheers
> -- 
> Mateusz Loskot
> http://mateusz.loskot.net