Modify address check query to obtain well-defined result
The way in which UNION does not yield the desired result, because (a) UNION
merges results and (b) the result order is undefined. This patch changes the
query to select the counts as columns and hence provides a well-defined order.
# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS
#
# The hosts that Postfix will try to connect to and query from.
hosts = localhost
# The user name and password to log into the pgsql server.
user = postfix
password = some_password
# The database name on the servers.
dbname = mailsys
# The SQL query template used to search the database
# Use this VIEW-based template if you didn't create the pgsql function
# `postfix_virtual_uid_map'.
#query = SELECT uid FROM postfix_uid WHERE address='%s'
# the recommended, function-based template
query = SELECT uid FROM postfix_virtual_uid_map('%u', '%d')