What happens when you use ``select_for_update`` with ``select_related``?

197 views
Skip to first unread message

Yo-Yo Ma

unread,
Aug 19, 2012, 11:02:35 PM8/19/12
to django...@googlegroups.com
Given a model ``Employee`` with a foreign key ``company`` pointing to a model called ``Company``, would the following example lock both the ``Employee`` and ``Company`` rows that were selected?

employee = Employee.objects.select_for_update().select_related('company').get(pk=1)

Or, would only the ``Employee`` row be locked?

Joseph Mutumi

unread,
Aug 23, 2012, 3:35:52 PM8/23/12
to django...@googlegroups.com
I'm not sure but you can look at the generated query and post it to the
relevant database mailing list?

Go in through: manage.py shell then follow instructions in FAQ
https://docs.djangoproject.com/en/dev/faq/models/#how-can-i-see-the-raw-sql-queries-django-is-running



--
You received this message because you are subscribed to the Google Groups "Django users" group.
To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/Ps3gJ6JiSnMJ.
To post to this group, send email to django...@googlegroups.com.
To unsubscribe from this group, send email to django-users...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

Reply all
Reply to author
Forward
0 new messages