table-level and row-level locks.

Поиск
Список
Период
Сортировка
От Jenny -
Тема table-level and row-level locks.
Дата
Msg-id BAY1-F113EcMUfGHUZB0000f050@hotmail.com
обсуждение
Список pgsql-hackers
Iam trying to acquire rowlevel locks in postgresql. I try doing this:
 'select * from students where name='Larry' for update;
But by looking at the holding array of proclock , I've noticed that by doing this only
AccessShareLock gets acquired which is a table level lock.
How do I acquire rowlevelock and what fields of Lock or Proclock datastructures indicate it.
Thanks
Jenny


MSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*.

В списке pgsql-hackers по дате отправления: