# HG changeset patch
# User Pascal Volk <neverseen@users.sourceforge.net>
# Date 1204497719 0
# Node ID 8f6e34549c26b04dfa4d472fe6d3da58457f1a89
# Parent  e3d3dbeb5b845c560a8341cec71a594ca43a506d
* 'pgsql-transport.cf'
    - fixed query

* 'pgsql-smtpd_sender_login_maps.cf'
    - added missing ' at end of query

diff -r e3d3dbeb5b84 -r 8f6e34549c26 ChangeLog
--- 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>
 
diff -r e3d3dbeb5b84 -r 8f6e34549c26 pgsql-smtpd_sender_login_maps.cf
--- 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'
diff -r e3d3dbeb5b84 -r 8f6e34549c26 pgsql-transport.cf
--- 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'