Good point. But in my point of view you wont use record versioning at all your tables, just in the ones that have sensitive data. And yet, you dont use ondelete cascade in all tables too... I still think record versioning should have this standard behaviour.
On Sunday, February 3, 2013 1:14:21 AM UTC-2, Massimo Di Pierro wrote: > > I should explain my answer. In order to have record versioning, record > must be copied. To have a cascade delete we would have to loop and copy > each individual record. Those records themselves could have references. > More looping. etc. This are even more complex since there may be > non-trivial circular references. > > On Saturday, 2 February 2013 21:10:56 UTC-6, Massimo Di Pierro wrote: >> >> It is possible but very very inefficient since it would not be handled at >> the database level. >> >> On Saturday, 2 February 2013 15:44:20 UTC-6, Felipe Meirelles wrote: >>> >>> I think they should, to be compatible with the default behaviour. Is >>> this possible to do? >>> >>> On Saturday, February 2, 2013 6:41:25 PM UTC-2, Massimo Di Pierro wrote: >>>> >>>> Good point. No. they are not set to is_active=False. Should they? >>>> >>>> On Saturday, 2 February 2013 06:20:47 UTC-6, Felipe Meirelles wrote: >>>>> >>>>> No, I mean, when a record is "delete" aka is_active is seted to False, >>>>> the other records there make reference to it are seted false too? >>>>> >>>>> On Friday, February 1, 2013 6:19:52 PM UTC-2, Massimo Di Pierro wrote: >>>>>> >>>>>> When using versioning. Latest versions of records are never deleted, >>>>>> only filtered out. I think cascade should work as expected. >>>>>> >>>>>> On Friday, 1 February 2013 11:54:25 UTC-6, Felipe Meirelles wrote: >>>>>>> >>>>>>> The cascade feature should work for record versioning enabled tables? >>>>>>> >>>>>>> Thanks. >>>>>>> >>>>>> -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
