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

[Michael Schulz]

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



---------- 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
 -----------------------------------------------------------



-- 
-----------------------------------------------------------
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
-----------------------------------------------------------