Chris Travers wrote on 06.01.2013 03:18:
i.e. where on UPDATE foo, all rows selected from foo during the update are locked unless the subselect specifically states otherwise.
That would strike *me* as wrong. The UPDATE should only lock the rows that were actually updated, not those that were selected. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general