> 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.
In response to
pgsql-novice by date
|Next:||From: alex||Date: 2005-06-26 11:42:09|
|Subject: Re: limit tables size|
|Previous:||From: alex||Date: 2005-06-26 06:02:04|
|Subject: Re: unpacking composite values|