Keith Worthington wrote:
> alex wrote:
>> Is it possible to limit the size or the number of rows of table, in a
>> FIFO mode for example ??
> Hmmm, do you mean that every time a row is INSERTed that you want to
> delete the oldest row?
> How about a serial column and an AFTER INSERT trigger? The trigger
> could search for and delete the row with the smallest serial value.
> This could get real slow if your table is huge. If the volume is high
> enough then you will have to handle wrap around. You could simply
> write a script that would subtract the minimum value from all the rows
> when the serial reached the maximum.
Yes It may be the solution, look at the index some times and delete the
old ones ...
In response to
pgsql-novice by date
|Next:||From: Minal||Date: 2005-06-27 06:34:28|
|Subject: Problem with startup|
|Previous:||From: Keith Worthington||Date: 2005-06-26 11:26:44|
|Subject: Re: unpacking composite values|