martin f. krafft <madduck@madduck.net> [Sun, 15 Apr 2012 17:51:00 +0200] rev 550
Fix transport_maps function for non-existent domains
The postfix_transport_maps function had a bug causing
2012-04-15 17:40:22 CEST LOG: statement: SELECT transport FROM postfix_transport_map('logcheck', 'domine.madduck.net');
2012-04-15 17:40:22 CEST ERROR: query returned no rows
when the domain was not in the database. This would make did be NULL and make
the query fail.
This patch moves the tid query until after a check for did. If the latter is
NULL, the function RETURNs (rather than fails).
martin f. krafft <madduck@madduck.net> [Sun, 15 Apr 2012 17:36:26 +0200] rev 549
Revert caching of destination interpolation
Since 'destination' comes from the table in the query, it cannot be cached
across queries! Doh!
Pascal Volk <user@localhost.localdomain.org> [Sun, 15 Apr 2012 15:30:16 +0000] rev 548
pgsql: update_tables_*: Added missing `NOT' to `… tid DROP NOT NULL;'.
Pascal Volk <user@localhost.localdomain.org> [Sun, 15 Apr 2012 12:54:16 +0000] rev 547
pgsql: Create column `note' as text.