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(at)rbt(dot)ca>
>
> PGP Key: http://www.rbt.ca/rbtpub.asc
-- End of PGP section, PGP failed!

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073