# HG changeset patch
# User Pascal Volk <user@localhost.localdomain.org>
# Date 1346105364 0
# Node ID 86b967c0f1a1cdc752b3a43b7f869f1c4bed9c05
# Parent  cdbe200c0ecc155fc4b97367addbb6d730d8d39a
pgsql: Don't select service_set.ssid in dovecotpassword() unconditional.
This may cause an empty result, which will make logins impossible.

diff -r cdbe200c0ecc -r 86b967c0f1a1 pgsql/create_tables.pgsql
--- a/pgsql/create_tables.pgsql	Mon Aug 27 20:49:31 2012 +0000
+++ b/pgsql/create_tables.pgsql	Mon Aug 27 22:09:24 2012 +0000
@@ -353,7 +353,6 @@
                                   FROM domain_name
                                  WHERE domainname = the_domain)
                AND local_part = localpart
-               AND service_set.ssid = users.ssid
                AND users.gid = domain_data.gid
                AND CASE WHEN
                   users.ssid IS NOT NULL
diff -r cdbe200c0ecc -r 86b967c0f1a1 pgsql/update_tables_0.5.x-0.6.pgsql
--- a/pgsql/update_tables_0.5.x-0.6.pgsql	Mon Aug 27 20:49:31 2012 +0000
+++ b/pgsql/update_tables_0.5.x-0.6.pgsql	Mon Aug 27 22:09:24 2012 +0000
@@ -307,7 +307,6 @@
                                   FROM domain_name
                                  WHERE domainname = the_domain)
                AND local_part = localpart
-               AND service_set.ssid = users.ssid
                AND users.gid = domain_data.gid
                AND CASE WHEN
                   users.ssid IS NOT NULL