[Dovecot] expire plugin with pgsql not working

LÉVAI Dániel leva at ecentrum.hu
Mon Dec 22 03:10:34 EET 2008


Hi!

I've configured dovecot, and created the db/table/trigger according to 
http://wiki.dovecot.org/Quota/Dict. I'm using dovecot-1.1.7 and pgsql. 
When moving a message inside the "monitored" directory, the expires 
table won't get updated because of an error:

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?

Daniel

-- 
LEVAI Daniel
PGP key ID = 0x4AC0A4B1
Key fingerprint = D037 03B9 C12D D338 4412  2D83 1373 917A 4AC0 A4B1


More information about the dovecot mailing list