From: Michael Orlitzky <michael@orlitzky.com>
Date: Sat, 20 Mar 2010 18:13:44 +0000 (-0400)
Subject: Use the 'mailbox' table instead of 'alias'; the alias.goto field can contain a list... 
X-Git-Tag: 0.0.1~149
X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=commitdiff_plain;h=1e4cad3a4f6938ca07bc99078108d466bf146b24

Use the 'mailbox' table instead of 'alias'; the alias.goto field can contain a list of comma-separated values which gets messy.
---

diff --git a/src/postfixadmin_db.rb b/src/postfixadmin_db.rb
index 7998bfe..5291a53 100644
--- a/src/postfixadmin_db.rb
+++ b/src/postfixadmin_db.rb
@@ -33,7 +33,7 @@ class PostfixadminDb
 
       # If address = goto, then the alias basically says, "really
       # deliver to that address; it's not an alias."
-      sql_query = 'SELECT address FROM alias WHERE address = goto;'
+      sql_query = 'SELECT username FROM mailbox;'
       result = connection.query(sql_query)
       connection.close()
     rescue PGError => e