The autoresponses table

A row in the autoresponses table corresponds to an autoresponse sent. The Sieve vacation command uses this table to avoid an autoresponse loop.

The sent_from column records who sent the response. This is the address that appeared in the message's From field, not the user responsible for sending it.

The sent_to column is the autoresponse's To field.

The expires_at field is the end of the protection period: The code that avoids mailing list loops refuses to send another autoresponse with the same data until the end of the protection period. The default is seven days, so in practice this means that correspondents get at most one vacation message every seven days.

The handle field can be used to send different autoresponses from the same address, and treat them entirely distinctly. Normally it is set to a hash based on the autoresponse message's content.

create table autoresponses ( -- Grant: select, insert id serial primary key, sent_from integer not null references addresses(id), sent_to integer not null references addresses(id), expires_at timestamp with time zone not null default current_timestamp+interval '7 days', handle text );

The autoresponses table was introduced in version 2.04.

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

Relevant links

About this page

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