Re: ACCESS EXCLUSIVE LOCK

From: Andrew - Supernews <andrew+nonews(at)supernews(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ACCESS EXCLUSIVE LOCK
Date: 2006-03-02 14:07:14
Message-ID: slrne0dv0i.5md.andrew+nonews@atlantis.supernews.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On 2006-03-02, seth(dot)m(dot)green(at)gmail(dot)com <seth(dot)m(dot)green(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message James_Hughes 2006-03-02 14:15:37 Re: Initdb on Windows 2003
Previous Message seth.m.green 2006-03-02 13:55:10 Re: ACCESS EXCLUSIVE LOCK

Browse pgsql-patches by date

  From Date Subject
Next Message seth.m.green 2006-03-02 14:16:00 Re: ACCESS EXCLUSIVE LOCK
Previous Message seth.m.green 2006-03-02 13:55:10 Re: ACCESS EXCLUSIVE LOCK