On 12/27/05, Aftab Alam <aalam@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx > [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx]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 ;)
