Bruce Momjian <[email protected]> wrote: > We could go in the direction you suggested, but it seems out-of-place in > the UPDATE/DELETE docs since it gets into a lot of details. Maybe in > the locking chapter? How about if the UPDATE and DELETE examples only show how to get limit and order by with a cte, and remove all references to locking. No for update, deadlocks etc. The examples use primary keys and not ctid. Anyone just trying to do simple limit and order by without locking problems will get what they need, and won't be confused by the locking complexity. Anyone trying to solve lock contention needs to understand locking and should be looking at that chapter. The explanation for deadlock avoidance should be there as you suggest. Perhaps the update and delete examples can link to them. If you think this is the right approach I'm willing to give it a go?
Thanks, Bernice
