Message-ID: <01BF170C.818A3CB0@makushina.rtsoft.msk.ru>
From: "Natalya S. Makushina" <mak@rtsoft.msk.ru>
To: "'pgsql-general@hub.org'" <pgsql-interfaces@hub.org>
Subject: Email system and PostgreSQL
Date: Fri, 15 Oct 1999 12:55:05 +0300
Encoding: 20 TEXT

Hi all!

We have database of our clients on PostgreSQL and want to send email for 
some extracts from this database. One extract is permanent list, others are 
temporary ones.
If i try to send email using triggers, email sender adress is like as 
"postgres@company.domain" . It's not right.

Also we have a mailing list manager - Majordomo.
My questions are:
1. Does any way exist to synchronize permanent list and database? May be 
using triggers.
2. Does any way exist to generate temporary list "on a fly" from database 
and to send this list to Majordomo? For example sending subscribe or 
unsubscribe email to Majorodomo.

Does anybody interest in disscussion of this problem?
Any ideas would be greatfully appreciated!

					Best regards, Natalya Makushina.