# HG changeset patch
# User Pascal Volk <neverseen@users.sourceforge.net>
# Date 1250842673 0
# Node ID 988b9a7199298f6bbb6b99592bfdc627e23ac221
# Parent  68af38212ff5bb69f1f720045d12d6ba6d372bf9
Removed the currently not needed WHERE clause from the VIEW.

diff -r 68af38212ff5 -r 988b9a719929 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.