Third repeat post. Sorry if previous ones suddenly pop up too.
ARCHIVE TABLES
this is a further development ofthe read-only tables proposal,
WHich answers Tom's question - 'how such a tables comes to exists'
and inspired by someones (can't find the mail, sorry) suggestion
to think of them as
Out of curiosity, what would be required to allow deletes (but not
updates)? My thinking is that you'd want *some* way to be able to prune
data. Since you won't want to store an entire XID/CID for the delete, I
think it would be acceptable to keep a table of XID/CID values for
deletes and just
On 5/2/05, Jim C. Nasby wrote:
Out of curiosity, what would be required to allow deletes (but not
updates)?
The same as updates (because updates are essentially a delete + insert).
My thinking is that you'd want *some* way to be able to prune
data. Since you won't want to store an entire