Removed the currently not needed WHERE clause from the VIEW.
authorPascal Volk <neverseen@users.sourceforge.net>
Fri, 21 Aug 2009 08:17:53 +0000
changeset 125 988b9a719929
parent 124 68af38212ff5
child 126 3643a0777e77
Removed the currently not needed WHERE clause from the VIEW.
update_tables_0.5.x_for_dovecot-1.2.x.pgsql
--- 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.