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

[Michael Schulz]

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.

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