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
