--- a/pgsql/create_optional_types_and_functions.pgsql	Wed Oct 26 23:32:58 2011 +0000
+++ b/pgsql/create_optional_types_and_functions.pgsql	Fri Oct 28 15:51:31 2011 +0000
@@ -288,7 +288,7 @@
     mail        text
 );
 -- ---
--- Data type for function dovecotquotauser(varchar, varchar) 
+-- Data type for function dovecotquotauser(varchar, varchar)
 -- ---
 CREATE TYPE dovecotquotauser AS (
     userid      varchar(320),
@@ -410,11 +410,12 @@
     BEGIN
         FOR record IN
             SELECT userid, passwd, smtp, pop3, imap, managesieve
-              FROM users
+              FROM users, service_set
              WHERE gid = (SELECT gid
                             FROM domain_name
                            WHERE domainname = the_domain)
                AND local_part = localpart
+               AND service_set.ssid = users.ssid
             LOOP
                 RETURN NEXT record;
             END LOOP;