Thanks for your answers guys. I have another question related to this topic.
Say i want to reference an authorized user instead of a person table:
db.define_table('cat',
Field('name'),
Field('owner', db.auth_user,
default=auth.user_id,readable=False,writable=False),)
So that the "owner" of the cat is the logged in user.
Also i have a view that displays the cat owner.
Lets say i want to have the option to either keep the "cat" or purge it or
five it to another owner (in general take an action), after the user has
been deleted. How can i do it?
If i use ondelete="CASCADE" the cat will be deleted
ondelete="SET NULL" the owner of the cat will be NULL
ondelete="NO ACTION"
but there is no way to define take an action. Any ideas??
