On Thu, Jan 28, 2010 at 10:40 PM, Brian Evans - Postfix List <grkni...@scent-team.com> wrote: > On 1/28/2010 4:12 PM, Serge Fonville wrote: >>>>> I using virtual_alias_maps with mysql for storage. Working fine. >>>>> >>>>> Does anyone have a suggestion on how to update a timestamp field in the >>>>> mysql table when postfix finds a virtual_alias_maps match? >>>>> >>>>> I'm looking for a way to measure alias usage and cull unused aliases. >>>>> >>>>> >>>> Have you considered a stored procedure? >>>> >>>> >>> Stored procedures do not work in Postfix without code changes because >>> the |CLIENT_MULTI_RESULTS connect flag, for MySQL API, is not turned on. >>> >> From the manual: >> http://dev.mysql.com/doc/refman/5.0/en/mysql-real-connect.html >> CLIENT_MULTI_RESULTS >> >> > [...] >> If your program uses CALL statements to execute stored procedures, the >> CLIENT_MULTI_RESULTS flag must be enabled. >> > Reread this ^^^.
If you use a SELECT query, does it use CALL? -- http://www.sergefonville.nl Convince Google!! They need to support Adsense over SSL https://www.google.com/adsense/support/bin/answer.py?hl=en&answer=10528 http://www.google.com/support/forum/p/AdSense/thread?tid=1884bc9310d9f923&hl=en
