Re: Truncate doc fix
От | Bruce Momjian |
---|---|
Тема | Re: Truncate doc fix |
Дата | |
Msg-id | 200212060315.gB63F9I24321@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Truncate doc fix (Rod Taylor <rbt@rbt.ca>) |
Список | pgsql-patches |
Patch applied. Thanks. --------------------------------------------------------------------------- Rod Taylor wrote: -- Start of PGP signed section. > With a recent commit truncate is transaction safe in 7.4. > > > Index: doc/src/sgml/ref/truncate.sgml > =================================================================== > RCS file: > /projects/cvsroot/pgsql-server/doc/src/sgml/ref/truncate.sgml,v > 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> > - > - <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> > > <refsect1 id="R1-SQL-TRUNCATE-2"> > --- 84,89 ---- > > > -- > Rod Taylor <rbt@rbt.ca> > > PGP Key: http://www.rbt.ca/rbtpub.asc -- End of PGP section, PGP failed! -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-patches по дате отправления: