[Dovecot] expire plugin with pgsql not working

[Timo Sirainen]

On Dec 22, 2008, at 3:10 AM, LÉVAI Dániel wrote:

> I've configured dovecot, and created the db/table/trigger according to
> http://wiki.dovecot.org/Quota/Dict.

Look into http://wiki.dovecot.org/Plugins/Expire instead. Although I  
just had to fix that page too.

> statement: INSERT INTO expires (expire_stamp, mailbox) VALUES
> ('1229993423', 'leva/spamassassin.SPAM')
> INSERT ERROR:  null value in column "username" violates not-null
> constraint
>
> Wonder why doesn't dovecot pass the username too. What could be the
> problem?

It doesn't need to have a username field. Leave it out of the primary  
key (and remove the entire field).