Re: Using C# to create stored procedures - Mailing list pgsql-general

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@fetter.org>
>To: Andrus <kobruleht2@hot.ee>
>CC: pgsql-general@postgresql.org
>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@hotmail.com>; 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@hotmail.com>; 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@hotmail.com>; 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@postgresql.org>; 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@postgresql.org>; 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@postgresql.org>; 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@news.hub.org>
>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@postgresql.org?body=help>
>List-ID: <pgsql-general.postgresql.org>
>List-Owner: <mailto:pgsql-general-owner@postgresql.org>
>List-Post: <mailto:pgsql-general@postgresql.org>
>List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
>List-Unsubscribe:
><mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
>Precedence: bulk
>Return-Path: pgsql-general-owner+m111972=mgainty=hotmail.com@postgresql.org
>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@postgresql.org so that your
> >       message can get through to the mailing list cleanly
>
>--
>David Fetter <david@fetter.org> 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