On 2006-03-02, seth.m.green@gmail.com <seth.m.green@gmail.com> wrote:
> No. Here is the offending SP:
>
> CREATE OR REPLACE FUNCTION update_my_cache() RETURNS void AS '
> BEGIN
>
> TRUNCATE TABLE my_cache_table;
TRUNCATE is another command that takes an access exclusive lock.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services