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

2012-08-19 Thread Yo-Yo Ma
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 t

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

2012-08-23 Thread Joseph Mutumi
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 On Mon, Aug 20, 2012 at 6:0