Make PL/pgSQL function feed back identity for mailboxes/relocated when there are catchall destinations. Without catchall aliases, if no virtual_alias matches, the query can just return NULL and Postfix will later check mailboxes/relocated for the address to rewrite. However, since virtual aliases are handled long before mailboxes/relocated, a catchall alias would also catch mail to mailboxes and relocated addresses, which we do not want. The way to tell postfix to keep delivering is for the virtual alias map to return the search key itself (identity function). This patch changes the postfix_virtual_alias_maps Pl/pgSQL function to do exactly that, but only if there are catchall destinations defined for the domain in question — otherwise it returns NULL when no match is found.

     1

# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS

     2

#

     3

# The hosts that Postfix will try to connect to and query from.

     4

hosts = localhost

     5

     6

# The user name and password to log into the pgsql server.

     7

user = postfix

     8

password = some_password

     9

    10

# The database name on the servers.

    11

dbname = mailsys

    12

    13

# The SQL query template used to search the database

    14

query = SELECT uid FROM postfix_virtual_uid_map('%u', '%d')