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
Jim C. Nasby, Sr. Engineering Consultant      [EMAIL PROTECTED]
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461
Index: doc/src/sgml/mvcc.sgml
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/mvcc.sgml,v
retrieving revision 2.53
diff -u -r2.53 mvcc.sgml
--- doc/src/sgml/mvcc.sgml      7 Nov 2005 17:36:44 -0000       2.53
+++ doc/src/sgml/mvcc.sgml      4 Mar 2006 03:07:08 -0000
@@ -710,7 +710,7 @@
         Acquired by the <command>ALTER TABLE</command>, <command>DROP
-        TABLE</command>, <command>REINDEX</command>,
+        TABLE</command>, <command>TRUNCATE</command>, 
         <command>CLUSTER</command>, and <command>VACUUM FULL</command>
         commands.  This is also the default lock mode for <command>LOCK
         TABLE</command> statements that do not specify a mode explicitly.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to