I'm a bit confused right now. I thought for sure that LMTP
wasn't using a transaction for PostgreSQL, but the logs don't
lie.
My issue is that when I stop dbmail-lmtpd without stopping
postfix first, and there is an LMTP message in the pipe, I
end up with an entry in dbmail_messageblks that has a
messageblk of '', it's completely empty. This doesn't make
the client too happy when I try and check a mailbox with
a message like this in there.
What I'm lost with, is it seems like if postgresql is using
a transaction, it shouldn't be making it to the commit stage
and that would mean that nothing should get entered. I'm
having a hard time duplicating the issue unless I kill the
process during a normal amount of incoming mail.
Which it looks like if I do that, then I'm losing Email.
Anyone else see items when they do a:
select * from dbmail_messages where unique_id = ''
- or, a bit more abusive -
select * from dbmail_messageblks where messageblk = ''
--
David A. Niblett | email: [EMAIL PROTECTED]
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
