Re: automatic verifications

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: automatic verifications
Дата
Msg-id 87n09pixaz.fsf@asmodeus.mcnaught.org
обсуждение исходный текст
Ответ на automatic verifications  (Melanie Bergeron <mbergeron_pg@globeecom.com>)
Список pgsql-general
Melanie Bergeron <mbergeron_pg@globeecom.com> writes:

> Hi!
>
> I am new with PostgreSQL and I want to know if this database give the
> possibility  to verify automatically, each night, if some records are
> too old (by example, if session_date is older than a month) and if so
> delete them.

That's not really something you would build into a server.  I'd do it
by writing a maintenance script and having it run by 'cron'.  The
script would just do a "DELETE FROM sessions WHERE session_date < ..."

-Doug

В списке pgsql-general по дате отправления:

Предыдущее
От: "Rick Gigger"
Дата:
Сообщение: Re: Firebird and PostgreSQL at the DB Corral.
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: automatic verifications