The deliveries table

deliveries contains outgoing messages which haven't yet been handed over to the mail smarthost. It works together with the delivery_recipients table.

There are at least five cases in which Archiveopteryx needs to send outgoing mail: the Sieve redirect, reject and vacation commands, messages submitted using SMTP/Submit and finally error messages resulting from failure in the the first four cases. In all five cases, the outgoing messages are deposited in the deliveries and delivery_recpients table, and later they're taken from those tables and delivered to the smarthost.

sender is the message sender. If there is a problem, sender is the address which will be notified.

message points to the message which is to be sent.

injected_at is the time when the message was originally submitted as outgoing mail and expires_at is the time when Archiveopteryx will give up delivering it. 


create table deliveries (
    -- Grant: select, insert, delete, update
    id          serial primary key,
    sender      integer not null references addresses(id),
    message     integer not null references messages(id)
                on delete cascade
                unique,
    injected_at timestamp with time zone,
    expires_at  timestamp with time zone
);

The deliveries table was introduced in version 1.12.

In case of questions, please write to info@aox.org.

Relevant links

About this page

Last modified: 2010-11-19
Location: aox.org/db/deliveries