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), 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
