Re: TODO item completed - Make a transaction-safe TRUNCATE

TODO updated:

    Make a transaction-safe TRUNCATE (Rod)

CVS commit was:

    date: 2002/11/23 04:05:51;  author: momjian;  state: Exp;  lines: +14 -15
    Transaction safe Truncate

    Rod Taylor


---------------------------------------------------------------------------

Rod Taylor wrote:
-- Start of PGP signed section.
> - Make a transaction-safe TRUNCATE
>
> rbt=# select version();
>                                 version
> ------------------------------------------------------------------------
>  PostgreSQL 7.4devel on i386-unknown-freebsd4.7, compiled by GCC 2.95.4
> (1 row)
>
> rbt=# select * from junk;
>    col1
> -----------
>  some text
> (1 row)
>
> rbt=# begin;
> BEGIN
> rbt=# truncate junk;
> TRUNCATE TABLE
> rbt=# select * from junk;
>  col1
> ------
> (0 rows)
>
> rbt=# rollback;
> ROLLBACK
> rbt=# select * from junk;
>    col1
> -----------
>  some text
> (1 row)
>
>
>
>
> --
> 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