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