* 'pgsql-transport.cf'
authorPascal Volk <neverseen@users.sourceforge.net>
Sun, 02 Mar 2008 22:41:59 +0000
changeset 10 8f6e34549c26
parent 9 e3d3dbeb5b84
child 11 7a5bd38c5b98
* 'pgsql-transport.cf' - fixed query * 'pgsql-smtpd_sender_login_maps.cf' - added missing ' at end of query
ChangeLog
pgsql-smtpd_sender_login_maps.cf
pgsql-transport.cf
--- a/ChangeLog	Sun Mar 02 20:22:00 2008 +0000
+++ b/ChangeLog	Sun Mar 02 22:41:59 2008 +0000
@@ -11,6 +11,8 @@
 	* VirtualMailManager/VirtualMailManager.py: some small fixes
 	* VirtualMailManager/Domain.py: Added Transport-stuff
 	* vmm.cfg: Added option transport in section misc
+	* pgsql-transport.cf: changed query for new table layout
+	* pgsql-smtpd_sender_login_maps.cf: added missing single quote in query
 
 2008-02-02  Pascal Volk  <neverseen@users.sourceforge.net>
 
--- a/pgsql-smtpd_sender_login_maps.cf	Sun Mar 02 20:22:00 2008 +0000
+++ b/pgsql-smtpd_sender_login_maps.cf	Sun Mar 02 22:41:59 2008 +0000
@@ -10,4 +10,4 @@
 
 # Postfix 2.2 and later The SQL query template. See pgsql_table(5).
 query = SELECT address FROM postfix_maildir WHERE address='%s'
- UNION SELECT destination FROM postfix_alias WHERE address='%s
+ UNION SELECT destination FROM postfix_alias WHERE address='%s'
--- a/pgsql-transport.cf	Sun Mar 02 20:22:00 2008 +0000
+++ b/pgsql-transport.cf	Sun Mar 02 22:41:59 2008 +0000
@@ -9,4 +9,4 @@
 dbname = mailsys
 
 # Postfix 2.2 and later The SQL query template. See pgsql_table(5).
-query = SELECT transport FROM postfix_transport WHERE domainname='%s'
+query = SELECT transport FROM postfix_transport WHERE address='%s'