AW: [Spam:medium] [Mapbender-dev] Fwd: [Mapbender-users] problems at creatingmapbender2.5 schema

[Manns, FB 62]

Hi Michael,

thank you  
something like this is what i hoped to hear.


I've already commented line 5+6 like this:

#########################################
  --CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
  --HANDLER plpgsql_call_handler;

 CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
  HANDLER plpgsql_call_handler;


CREATE FUNCTION gettext(locale_arg text, string text) RETURNS character varying
    AS $$
 DECLARE

..
..
..
..
..
##########################################

and everything looks fine.


cheers Marc


-----Ursprüngliche Nachricht-----
Von: Michael Schulz [mailto:mschulz at webgis.de]
Gesendet: Donnerstag, 17. April 2008 18:06
An: Mapbender Developer List
Betreff: [Spam:medium] [Mapbender-dev] Fwd: [Mapbender-users] problems
at creatingmapbender2.5 schema


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
-----------------------------------------------------------
_______________________________________________
Mapbender_dev mailing list
Mapbender_dev at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapbender_dev