[Mapbender-dev] Fwd: [Mapbender-users] problems at creating mapbender2.5 schema

[Christoph Baudson]

Christoph Baudson schrieb:
> On Fri, April 18, 2008 5:49 pm, Michael Schulz wrote:
>   
>> Hi Christoph,
>>
>> plpgsql is one language with that you can create functions.However
>> this check creates a temporary "sql" function to determine whether
>> plpgsql is installed. So you won't need plpgsql installed.
>>     
>
> Thanks for your comment, and thanks for explaining. Brilliant, so we can
> use this solution after all! We should put it in rc2.
>   

Tried it, works like a charm. Will be part of rc2. Thanks Michael.

Christoph

> As there are no dumb questions: Couldn't we use a temporary SQL function
> for our gettext function and skip plpgsql? I guess not, but maybe someone
> can explain. I'm not that much into databases.
>
> Thanks,
>
> Christoph
>
>   
>> Cheers, Michael
>>
>>
>>
>> 2008/4/18 Christoph Baudson <christoph.baudson at wheregroup.com>:
>>     
>>> Michael Schulz schrieb:
>>>
>>>
>>>       
>>>> Hi,
>>>>
>>>> i've found this:
>>>>
>>>>
>>>>         
>>> http://andreas.scherbaum.la/blog/archives/346-create-language-if-not-exist.html
>>>       
>>>> Haven't tried it though, but it looks good.
>>>>
>>>> Cheers, Michael
>>>>
>>>>
>>>>         
>>>  Thanks for your suggestion Michael, however I fear that his solutions
>>> is no
>>> good, if I read the comments correctly...he used a function to check if
>>> plpgsql is there. But plpgsql is required for functions.
>>>
>>>  But another poster seems to have submitted a patch to PostgreSQL, let's
>>> see
>>> if we have this is in the next version.
>>>
>>>  For now, I have removed the CREATE LANGUAGE bit, as it is listed in the
>>> installation guide.
>>>
>>>  Have a nice weekend,
>>>
>>>  Christoph
>>>
>>>
>>>
>>>
>>>       
>>>> ---------- Forwarded message ----------
>>>> From: Michael Schulz <mschulz at webgis.de>
>>>> Date: 2008/4/17
>>>> Subject: Re: [Mapbender-users] problems at creating mapbender2.5
>>>>         
>>> schema
>>>       
>>>> To: Mapbender User List <mapbender_users at lists.osgeo.org>
>>>>
>>>>
>>>> Hi Marc,
>>>>
>>>>  the mapbender database must have the plpgsql language installed,
>>>>  because of the i18n functions. If your db has plpgsql already
>>>>  installed, then you can comment this statement from the schema.sql.
>>>>
>>>>  We should have look for a "check if exists" way to do this, because a
>>>>  lot of people will have plpgsql installed (e.g. from postgis).
>>>>
>>>>  Cheers, Michael
>>>>
>>>>
>>>>  2008/4/17 Marec <marec at t-online.de>:
>>>>
>>>>
>>>>
>>>>
>>>>         
>>>>> Hi list,
>>>>>
>>>>>
>>>>>           
>>>>  >
>>>>  >  i actually downloaded  the new mapbender(2.5rc1) release.
>>>>  >  Now i have a problem at creating the new Database schema.
>>>>  >
>>>>  >  If  i execute the "pgsql_schema.sql" i get following error
>>>>         
>>> message:
>>>       
>>>>  >
>>>>  >  ###############################################
>>>>  >
>>>>  >  ERROR:  language "plpgsql" already exists
>>>>  >
>>>>  >  #######################################
>>>>  >
>>>>  >
>>>>  >  Is the first statement a mandatory setting in the new release or
>>>>         
>>> can i
>>>       
>>>>  > delete it??
>>>>  >
>>>>  >  Because I couldn't find the first statemets in older releases.
>>>>  >
>>>>  >
>>>>  >  greetings Marc
>>>>  >  _______________________________________________
>>>>  >  Mapbender_users mailing list
>>>>  >  Mapbender_users at lists.osgeo.org
>>>>  >  http://lists.osgeo.org/mailman/listinfo/mapbender_users
>>>>  >
>>>>
>>>>
>>>>
>>>>  --
>>>>  -----------------------------------------------------------
>>>>  Michael Schulz
>>>>  mschulz at webgis.de
>>>>
>>>>  in medias res
>>>>  Gesellschaft für Informationstechnologie mbH
>>>>
>>>>  In den Weihermatten 66
>>>>  79108 Freiburg
>>>>
>>>>  Tel +49 (0)761 556959-5
>>>>  Fax +49 (0)761 556959-6
>>>>
>>>>  http://www.webgis.de / http://www.zopecms.de
>>>>  -----------------------------------------------------------
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>         
>>>  --
>>>  _______________________________________
>>>
>>>  W h e r e G r o u p GmbH & Co. KG
>>>
>>>  Siemensstraße 8
>>>  53121 Bonn
>>>  Germany
>>>
>>>  Christoph Baudson
>>>  Anwendungsentwickler
>>>
>>>  Fon: +49 (0)228 / 90 90 38 - 15
>>>  Fax: +49 (0)228 / 90 90 38 - 11
>>>  christoph.baudson at wheregroup.com
>>>  www.wheregroup.com
>>>  Amtsgericht Bonn, HRA 6788
>>>  _______________________________________
>>>
>>>  Komplementärin:
>>>  WhereGroup Verwaltungs GmbH
>>>  vertreten durch:
>>>  Arnulf Christl, Olaf Knopp, Peter Stamm
>>>  _______________________________________
>>>
>>>
>>>  _______________________________________________
>>>  Mapbender_dev mailing list
>>>  Mapbender_dev at lists.osgeo.org
>>>  http://lists.osgeo.org/mailman/listinfo/mapbender_dev
>>>
>>>       
>>
>> --
>> -----------------------------------------------------------
>> Michael Schulz
>> mschulz at webgis.de
>>
>> in medias res
>> Gesellschaft für Informationstechnologie mbH
>>
>> In den Weihermatten 66
>> 79108 Freiburg
>>
>> Tel +49 (0)761 556959-5
>> Fax +49 (0)761 556959-6
>>
>> http://www.webgis.de / http://www.zopecms.de
>> -----------------------------------------------------------
>> _______________________________________________
>> Mapbender_dev mailing list
>> Mapbender_dev at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapbender_dev
>>
>>     
>
>
> _______________________________________________
> Mapbender_dev mailing list
> Mapbender_dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapbender_dev
>   


-- 
_______________________________________

W h e r e G r o u p GmbH & Co. KG

Siemensstraße 8
53121 Bonn
Germany

Christoph Baudson
Anwendungsentwickler

Fon: +49 (0)228 / 90 90 38 - 15
Fax: +49 (0)228 / 90 90 38 - 11
christoph.baudson at wheregroup.com
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
_______________________________________

Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
_______________________________________