limit the number of entries in a table

From: "Schnack, Malte" <m(dot)schnack(at)mediascape(dot)de>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: limit the number of entries in a table
Date: 2001-08-03 10:45:03
Message-ID: 4041F5C624D2D411ACE90002B32C40CAA03910@exchange.mediascape.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello all,

is there any possibility to limit the number in a postgresql
table in the way that: if a new entry is inserted and the
limit is exceeded the oldest element is dropped.

Does anybody know how to have this problem handled by
postgresql-engine?

Thanks for your advice and best regards

malte.

Browse pgsql-novice by date

  From Date Subject
Next Message Horst Herb 2001-08-03 14:37:35 redo log
Previous Message Ken Corey 2001-08-03 10:27:31 Re: Knowing new item in table...