On Mon, Apr 04, 2005 at 09:32:31PM +0200, Kilian Krause wrote: > the query would be something like "delete from $mytable where > $insertdate < $(today-1month)" with the variables holding the correct > names etc. > > Yet I strongly disagree with this behaviour for a default. At least the > 1 month rollback sounds like too few from a data-warehouse point of view > and too much from a duty of secrecy point of view. The only real > alternative sounds to be a debconf asking for the proper length.
The alternative could be to do a rotation scheme; SELECT records from the source, INSERT them into the destination, then DELETE from the source. But that gets more complex. > Does that sound ok for everybody? Sounds fine to me. > > -- > Best regards, > Kilian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
