[pgsql-jp: 37808] Re: UPDATE ?????????????????

[YuGo]

??????
???????????????????????????????????? 
????????????????
http://www.postgresql.jp/document/pg814doc/html/explicit-locking.html#LOCKING-ROWS

???????????????update?????order by????????? 
?????????

> UPDATE ???????????????????????????
> ?????????????????????????
> 
> Perl ? CGI ? DBI ????? PostgreSQL 8.1.4 ?????? 180,000
> ?????????????????????????????? 3,000 ?
> ?? update ?? SQL ?????????
> AutoCommit ?????????????? commit/rollback ??????
> 
> ?? CGI ??1???15????????????????????????
> ??????
>> ERROR:  deadlock detected
>> DETAIL:  Process 8473 waits for ShareLock on transaction 2283079; blocked by process 8417.
>>         Process 8417 waits for ShareLock on transaction 2283137; blocked by process 8473.
> ??????????????where ?????? ?? UPDATE ????
> ???????? CGI ?? UPDATE ??? "SET CLIENT_ENCODING TO SJIS"
> ????????????????????? UPDATE ?????????
> ?????????????????????
> 
> ?????????????
>