Removed the currently not needed WHERE clause from the VIEW.
--- 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.