I were using Mysql MyISAM. But I want to enable transaction.
So i shifted to InnoDB.
Actually I have one model as below (*designed somebody i can't
change).
class Folder(models.Model):
folder_id=models.AutoField(primary_key=True)
user_name=models.ForeignKey(User)
folder_name=models.CharField(max_length=80)
parent_folder=models.ForeignKey('self')
At some point i want to insert in this table as below:
Folder(user_name_id=1,folder_name="s",parent_folder_id=0)
But it raises one error like this.
IntegrityError: (1452, 'Cannot add or update a child row: a foreign
key constraint fails (`myproject/folder_folder`, CONSTRAINT
`parent_folder_id_refs_folder_id_12515019` FOREIGN KEY
(`parent_folder_id`) REFERENCES `folder_folder` (`folder_id`))')
But with MyISAM there was no problem like this.......
Anyways i need Transaction functionality for other tables in the
database.
Is there any solution for this problem. Please Help me.
Thanks
Lima
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
