David--
Mono is DotNet on SUSE
Heres the main site ..beware this is rather complicated to install and
configure but once I&c
you can run .NET Framework as a SUSE Binary Image then allow the GAC to pull
in assemblies
This link will get you started
http://www.mono-project.com/VMware_Image
I dont believe Im saying this but Perl *might possibly be* an easier
development environment for interfacing to
Stored Procedures--
Then again if you have 3 or 4 servers in your LR and have time to install
and configure this might be
a worthwhile weekend project
I know of a SUSE engineer that worked at Novell developing this so give me a
shout if you REALLY get stuck
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official
business of Sender. This transmission is of a confidential nature and Sender
does not endorse distribution to any party other than intended recipient.
Sender does not necessarily endorse content contained within this
transmission.
From: David Fetter <david@xxxxxxxxxx>
To: Andrus <kobruleht2@xxxxxx>
CC: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] Using C# to create stored procedures
Date: Mon, 2 Apr 2007 10:43:24 -0700
MIME-Version: 1.0
Received: from postgresql.org ([200.46.204.71]) by
bay0-mc2-f20.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Mon, 2
Apr 2007 10:45:23 -0700
Received: from localhost (maia-4.hub.org [200.46.204.183])by postgresql.org
(Postfix) with ESMTP id 1CDD89FB698for <mgainty@xxxxxxxxxxx>; Mon, 2 Apr
2007 14:45:23 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org
[200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 74312-01 for
<mgainty@xxxxxxxxxxx>; Mon, 2 Apr 2007 14:45:22 -0300 (ADT)
Received: from postgresql.org (postgresql.org [200.46.204.71])by
postgresql.org (Postfix) with ESMTP id 07BB29FB30Ffor
<mgainty@xxxxxxxxxxx>; Mon, 2 Apr 2007 14:45:22 -0300 (ADT)
Received: from localhost (maia-4.hub.org [200.46.204.183])by postgresql.org
(Postfix) with ESMTP id 58CBE9FB2E7for
<pgsql-general-postgresql.org@xxxxxxxxxxxxxx>; Mon, 2 Apr 2007 14:43:30
-0300 (ADT)
Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org
[200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 70979-10 for
<pgsql-general-postgresql.org@xxxxxxxxxxxxxx>; Mon, 2 Apr 2007 14:43:25
-0300 (ADT)
Received: from fetter.org (start.fetter.org [66.92.188.65])by
postgresql.org (Postfix) with ESMTP id B7C6A9FB2E4for
<pgsql-general@xxxxxxxxxxxxxx>; Mon, 2 Apr 2007 14:43:25 -0300 (ADT)
Received: by fetter.org (Postfix, from userid 500)id 4468AF3CBC9; Mon, 2
Apr 2007 10:43:24 -0700 (PDT)
X-Message-Info:
LsUYwwHHNt2AlwlyMK8asddYvQnrjJPbBh1DBkmlDwlkxe5CK3eB33QYQy5fK3wA
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
References: <euikod$1ssc$1@xxxxxxxxxxxx>
User-Agent: Mutt/1.4.2.2i
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Mailing-List: pgsql-general
List-Archive: <http://archives.postgresql.org/pgsql-general>
List-Help: <mailto:majordomo@xxxxxxxxxxxxxx?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@xxxxxxxxxxxxxx>
List-Post: <mailto:pgsql-general@xxxxxxxxxxxxxx>
List-Subscribe: <mailto:majordomo@xxxxxxxxxxxxxx?body=sub%20pgsql-general>
List-Unsubscribe:
<mailto:majordomo@xxxxxxxxxxxxxx?body=unsub%20pgsql-general>
Precedence: bulk
Return-Path: pgsql-general-owner+m111972=mgainty=hotmail.com@xxxxxxxxxxxxxx
X-OriginalArrivalTime: 02 Apr 2007 17:45:23.0783 (UTC)
FILETIME=[B0D27570:01C7754E]
On Fri, Mar 30, 2007 at 12:19:44PM +0300, Andrus wrote:
> Any idea how to write server-side stored procedures in C# for
> PostgreSQL database ?
There's an old project called PL/Mono
<http://gborg.postgresql.org/project/plmono/projdisplay.php>, but as
far as I know it's unmaintained. You might want to try to contact the
author. :)
Cheers,
David.
> In windows .NET 2 framework should be used and in Linuc/Mac/Windows
> MONO should be used for this.
>
> How to install MONO engine as server-side language to PostgreSQL ?
>
> How to call .NET dlls from PostgreSQL stored procedure ?
>
> Andrus.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
> message can get through to the mailing list cleanly
--
David Fetter <david@xxxxxxxxxx> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
_________________________________________________________________
Exercise your brain! Try Flexicon.
http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglineapril07