id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
10088	for_share() as well as for_update() addition to Model.QuerySet	epandurski	Nick Pope	"Ticket #2705 is a very good idea I think.

PostgreSQL supports SELECT ... FOR SHARE locking mode, which is basically
the same as FOR UPDATE mode but it does not conflicts with other transaction
having obtained FOR SHARE mode for the row. 
(see http://www.postgresql.org/docs/8.3/static/sql-select.html#SQL-FOR-UPDATE-SHARE)
It very useful if you need to be sure that your selected rows are not 
modified since you have read them (which is true for almost every complex transaction). 

I am not sure if MySQL has this feature but in PostgreSQL it first-class citizen so
I believe for_share() and for_update() has to be implemented together.

"	New feature	assigned	Database layer (models, ORM)	dev	Normal		select_for_share	Adam Johnson	Accepted	1	0	0	1	0	0