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

Re: Transaction safe Truncate

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Transaction safe Truncate
Date: 2002-11-22 05:41:57
Message-ID: 200211220541.gAM5fvv10718@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Your patch has been added to the PostgreSQL unapplied patches list at:

	http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

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


Rod Taylor wrote:
> Didn't move anything anywhere.  Simply split cluster_rel into two parts.
> rebuild_rel() does the rebuilding steps.  Truncate uses this skipping
> the datacopy stage by calling with dataCopy = false.
> 
> 
> If wanted (separate patch), the below could (should?) probably move to
> heap.c:
> rebuild_rel
> make_new_heap
> copy_heap_data
> swap_relfilenodes
> 
> The below could (should?) move to index.c:
> get_indexattr_list
> recreate_indexattr
> 
> That leaves the below in cluster.c:
> cluster_rel
> cluster
> check_cluster_ownership
> get_table_to_cluster
> 
> 
> 
> -- 
> Rod Taylor <rbt(at)rbt(dot)ca>

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

-- 
  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

In response to

pgsql-patches by date

Next:From: Evgen PotemkinDate: 2002-11-22 11:02:11
Subject: Hierarchical queries a la Oracle. Patch.
Previous:From: Bruce MomjianDate: 2002-11-22 05:41:31
Subject: Re: documentation fix

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