[Dovecot] quota dict play nice with existing tables

Timo Sirainen tss at iki.fi
Tue Sep 14 19:51:29 EEST 2010


On Tue, 2010-09-14 at 17:49 +0100, Timo Sirainen wrote:
> On Tue, 2010-09-14 at 18:07 +0200, Miha Vrhovnik wrote:
> 
> > I'm trying to set Dovecot 2.0 with postgresql dict. It's kind of working but not as I'd like to. Dovecot expects to get a dedicated table for quota management. When I've run *doveadm quota recalc -A* I've noticed in the logs that Dovecot tries to run DELETE statements. Fortunately it didn't succeed as I've only given it SELECT and UPDATE permissions on the fields that it needs.
> > 
> > I'd like to configure it, in UPDATE only mode as rows already exist and there is no need to issue any other statement. 
> 
> Maybe some day, but it's not something I'm planning on implementing
> anytime soon. Feel free to poke around the code to see if there's a way
> to do it without horrible changes.

Maybe it could treat NULL value as "row not found" and DELETE could be
replaced with UPDATE to NULL. Maybe.




More information about the dovecot mailing list