X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 560CC9DC9C9 for ; Wed, 28 Dec 2005 09:56:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54514-04 for ; Wed, 28 Dec 2005 09:56:38 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.192]) by postgresql.org (Postfix) with ESMTP id 472839DC993 for ; Wed, 28 Dec 2005 09:56:32 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i23so601775wra for ; Wed, 28 Dec 2005 05:56:36 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=RJabCAz4cYvkZ1GjWl3RIFiha3Aie85pH3xiA6XlgZHs7wNcY2WePcg3U18lv+fTyv30VcHXqKHqUkU1Y8FPrHQdhylhkKD0BfBSJdVwJhpBEYAjaAyoV4WH1YIjaZOup4HeKIoVwSOlU/BM/OxilbGsjF8hoA6ndILCfovqxBg= Received: by 10.54.112.10 with SMTP id k10mr8375543wrc; Wed, 28 Dec 2005 05:56:36 -0800 (PST) Received: by 10.54.92.14 with HTTP; Wed, 28 Dec 2005 05:56:36 -0800 (PST) Message-ID: Date: Wed, 28 Dec 2005 08:56:36 -0500 From: Jaime Casanova To: aalam@tatashare.com Subject: Re: sending mail from Postgres Cc: Michael Fuhr , postgre In-Reply-To: <003c01c60b60$15e2d130$ec1010ac@aftabn463> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20051227174114.GA70280@winnie.fuhr.org> <003c01c60b60$15e2d130$ec1010ac@aftabn463> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.08 required=5 tests=[AWL=0.080] X-Spam-Score: 0.08 X-Spam-Level: X-Archive-Number: 200512/336 X-Sequence-Number: 20056 On 12/27/05, Aftab Alam wrote: > Hi Michael, > > thanks for your reply. > > you have mention that i can use plperlu, pltclu, or > plpython for sending mail, i am using windows version of postgres(7.3.1), > on cygwin i guess... so you have to get a version of one of those languages (tcl, perl, python) for cygwin > I have found that no dll in the postgres lib. for above mention language. > > kindly suggest, form where i can find those language lib, & how can i > install those lib. > > thanx & Regards, > aftab > > > > > 7.3.1 > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Michael Fuhr > Sent: Tuesday, December 27, 2005 11:11 PM > To: Aftab Alam > Cc: 'postgre' > Subject: Re: [ADMIN] sending mail from Postgres > > > On Tue, Dec 27, 2005 at 02:44:32PM +0530, Aftab Alam wrote: > > How can i send mail form postgresql. > > You could write a function in a language like plperlu, pltclu, or > plpython, but a problem with functions that have effects outside > the database is that those effects can't be undone if the transaction > rolls back. A common example is a trigger that sends email when a > table is changed: if the trigger fires and then you roll back the > transaction, it's too late to cancel the email. Depending on what > you're doing it might be better to use LISTEN/NOTIFY and have a > client program send email when it receives a notification (notifications > are sent only when the transaction commits). > > -- > Michael Fuhr > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;)