[Dovecot] quota dict with mysql 4.0

Timo Sirainen tss at iki.fi
Fri Mar 26 10:56:45 EET 2010

On 25.3.2010, at 11.24, Andre Hübner wrote:

> i use successfully mysql-quotasystem with dovecot 1.2.11 on different servers except for mysql 4.0 servers
> dovecot internally uses sql: "ON DUPLICATE KEY UPDATE" which was introduced in mysql 4.1

The original code supported dict-sql only if ON DUPLICATE KEY UPDATE was supported by the server. Later I added support for PostgreSQL and SQLite by having them use INSERT triggers that update the data if it already exists. I suppose MySQL 4.0 doesn't support these kind of triggers either?

Writing code manually to first try to UPDATE and if it fails then INSERT would be possible.. But too much trouble for me to spend time on.

More information about the dovecot mailing list