Forum OpenACS Development: Re: PL/SQL: acs_permission__grant_permission lock problem

Collapse
Posted by Gustaf Neumann on
This looks fine, although i would recommend to remove the "select count(*)..." from acs_permission__grant_permission, since these two operations smell after a race condition. In most cases, the count() should return 0, and since the EXCEPTION deals with the the duplicate case anyhow, i see no reason for the count().

-g

Collapse
Posted by Antonio Pisano on
I have removed count from grant proc and committed changes. I've seen there is some work going on in acs-kernel, so my upgrade became from 5.9.0d5 to 5.9.0d6

Please let me know about any possible issue.

All the best