Re: [HACKERS] ACCESS EXCLUSIVE LOCK - Mailing list pgsql-patches

From Jim C. Nasby
Subject Re: [HACKERS] ACCESS EXCLUSIVE LOCK
Date
Msg-id 20060304030857.GL82012@pervasive.com
Whole thread Raw
Responses Re: [HACKERS] ACCESS EXCLUSIVE LOCK
List pgsql-patches
On Fri, Mar 03, 2006 at 08:00:19PM -0700, Michael Fuhr wrote:
> On Fri, Mar 03, 2006 at 08:47:41PM -0600, Jim C. Nasby wrote:
> > You have a URL for where in the docs it says that? Sounds like it needs
> > to be updated to include TRUNCATE.
>
> http://www.postgresql.org/docs/7.4/static/explicit-locking.html#LOCKING-TABLES
>
> It doesn't say that only the listed commands acquire ACCESS EXCLUSIVE,
> just that certain commands do.  TRUNCATE isn't shown.

Patch against HEAD to add TRUNCATE to the list of commands that aquire
ACCESS EXCLUSIVE.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

Attachment

pgsql-patches by date:

Previous
From: Kris Jurka
Date:
Subject: Re: constant too large in port/gettimeofday
Next
From: Bruce Momjian
Date:
Subject: Re: OS X shared memory documentation