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

[Christoph Baudson]

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
_______________________________________