Skip site navigation (1) Skip section navigation (2)

Truncate doc fix

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Truncate doc fix
Date: 2002-12-06 03:02:23
Message-ID: 1039143742.72042.16.camel@jester (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
With a recent commit truncate is transaction safe in 7.4.

Index: doc/src/sgml/ref/truncate.sgml
RCS file:
retrieving revision 1.8
diff -c -r1.8 truncate.sgml
*** doc/src/sgml/ref/truncate.sgml	2002/05/18 15:44:47	1.8
--- doc/src/sgml/ref/truncate.sgml	2002/12/06 03:00:15
*** 84,95 ****
     <command>DELETE</command> but since it does not actually scan the
     table it is faster. This is most useful on large tables.
-   <para>
-    <command>TRUNCATE</command> cannot be executed inside a transaction
-    block (<command>BEGIN</>/<command>COMMIT</> pair), because there is
-    no way to roll it back.
-   </para>
   <refsect1 id="R1-SQL-TRUNCATE-2">
--- 84,89 ----

Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key:


pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-12-06 03:15:09
Subject: Re: Truncate doc fix
Previous:From: Peter EisentrautDate: 2002-12-05 23:21:17
Subject: Re: [PATCHES] Patch to make Turks happy.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group