update_tables_0.5.x_for_dovecot-1.2.x.pgsql
changeset 125 988b9a719929
parent 123 626c008a4a04
child 126 3643a0777e77
--- a/update_tables_0.5.x_for_dovecot-1.2.x.pgsql	Fri Aug 21 08:10:10 2009 +0000
+++ b/update_tables_0.5.x_for_dovecot-1.2.x.pgsql	Fri Aug 21 08:17:53 2009 +0000
@@ -8,8 +8,7 @@
     SELECT local_part || '@' || domain_name.domainname AS "user",
            passwd AS "password", smtp, pop3, imap, sieve
       FROM users
-           LEFT JOIN domain_name USING (gid)
-     WHERE domain_name.is_primary;
+           LEFT JOIN domain_name USING (gid);
 
 -- ---
 -- Change the user name to the name of your dovecot database user.