public inbox for [email protected]  

help / color / mirror / Atom feed

From: Bruce Momjian <[email protected]>
To: Rod Taylor <[email protected]>
Cc: PostgreSQL-documentation <[email protected]>
Subject: Re: TODO item completed - Make a transaction-safe TRUNCATE
Date: Mon, 17 Feb 2003 13:38:12 -0500 (EST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <1045407481.12011.69.camel@jester>


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 <[email protected]>
> 
> PGP Key: http://www.rbt.ca/rbtpub.asc
-- End of PGP section, PGP failed!

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: TODO item completed - Make a transaction-safe TRUNCATE
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox