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 <[EMAIL PROTECTED]>:
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 <[EMAIL PROTECTED]>
Date: 2008/4/17
Subject: Re: [Mapbender-users] problems at creating mapbender2.5
schema
To: Mapbender User List <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>:
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
> [EMAIL PROTECTED]
> http://lists.osgeo.org/mailman/listinfo/mapbender_users
>
--
-----------------------------------------------------------
Michael Schulz
[EMAIL PROTECTED]
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
[EMAIL PROTECTED]
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
_______________________________________
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
_______________________________________
_______________________________________________
Mapbender_dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapbender_dev
--
-----------------------------------------------------------
Michael Schulz
[EMAIL PROTECTED]
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
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapbender_dev
_______________________________________________
Mapbender_dev mailing list
[email protected]
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
[EMAIL PROTECTED]
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
_______________________________________
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
_______________________________________
_______________________________________________
Mapbender_dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapbender_dev
